November 19, 200223 yr Newbies I have read so must about the similarities and differences of these two funtions that I'm confused again. I don't know if I have ever read the answer to my question or not, but, Which of those calculations will return a date and then NOT update it? I have a calculation that is supposed to return the current date when a number is entered in another field. The date isn't supposed to change after that. If someone can explain this to me along with what storage options should be set, I would be most appreciative. Cheers, Mykol
November 19, 200223 yr You can use both, but its best to use stick with Status(CurrentDate) unless you need to use one of Today()s special "features"
November 20, 200223 yr Today can be stored and indexed, so it is good for generating value lists. However, Today only updates itself when the file is closed and re-opened. Status(CurrentDate) should be unsed in an unstored calculation so it is always updated, but then it cannot be indexed.
Create an account or sign in to comment