Newbies Mykol Posted November 19, 2002 Newbies Posted November 19, 2002 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
falkaholic Posted November 19, 2002 Posted November 19, 2002 You can use both, but its best to use stick with Status(CurrentDate) unless you need to use one of Today()s special "features"
Vaughan Posted November 20, 2002 Posted November 20, 2002 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now