today function in calculated value field

[dharkangel]

I just discovered I cannot use the [TODAY] function in a sharepoint calculated field. How can I get around that? I need to create this formula for export to an excel spreadheet:

=IF(AND([Status] = "Open", [TODAY]> [Commit Date]), "Late Open","")

thanks

 

[ouzojd]

You can use [Today] by creating a new column as Today, then creating your calculated field and then deleting the column called today.

1 problem is that it calculates once and then stores the value in SQL2000. It will only recalculate if you open the list item and save it again.

Cheers.

 

[dharkangel]

thank you