Comments on: Expiry columns and the [Today] value in SharePoint 2003

By: Jesper Simonsen

Jesper Simonsen — Tue, 05 Jan 2010 15:41:16 +0000

I like to add that I had a problem with this when working with SharePoint variations!

In the English variation the formula looked like this:
=IF(Expires=”",DATE(2099,1,1),Expires)

but in the Danish variation it had to look like this:
=IF(Expires=”";DATE(2099;1;1);Expires)

So just changing from variation (language) to another caused the problem.

Just wanted to let you know.

By: Aditi

Aditi — Fri, 13 Feb 2009 12:27:16 +0000

Nice post.. It helped. Thanks..

By: bloggingIT » Blog Archive » Don’t hide my announcements!

bloggingIT » Blog Archive » Don’t hide my announcements! — Mon, 05 Nov 2007 12:12:20 +0000

[...] A quick Google later, and I found This Much I Know, which pointed me in the direction of creating a calculated column and then putting some code to place a new date in, if the expiry is blank. [...]

By: John

John — Mon, 05 Nov 2007 12:03:08 +0000

That’s just what I needed! Thank you.

I only use Sharepoint as a minor part of my job, so silly problems like this are difficult to rectify.

This seems to be the most elegant solution for this particular problem though.