I have a table were I have a bunch of columns. One of them contains dates (Lookup from another table), and one of them is an IF-formula that should write “Yes” if it is today´s date today and “No” if it is not.
My formula looks like this:
IF(dateField = TODAY(), “Yes”, “No”)
The problem: No matter what date it is today and no matter what the dates are in the dateField, the IF-formula always writes “No” for all records.
What am I doing wrong and how do I fix it?
Thanks!
Instead of
dateField = TODAY()
try
IS_SAME(dateField,TODAY(),'day')
It seems more bulletproof than the equal to operator when it comes to dates. You may also want to set all your date fields – including calculated ones – to use GMT, even if you don’t bother with a timefield. I just finished a base with 20 or more date fields scattered throughout, and I had a devil of a time trying to figure out how I kept gaining or losing days. Set everything to GMT, and no more problems.
Instead of
dateField = TODAY()
try
IS_SAME(dateField,TODAY(),'day')
It seems more bulletproof than the equal to operator when it comes to dates. You may also want to set all your date fields – including calculated ones – to use GMT, even if you don’t bother with a timefield. I just finished a base with 20 or more date fields scattered throughout, and I had a devil of a time trying to figure out how I kept gaining or losing days. Set everything to GMT, and no more problems.
Thanks, worked perfectly!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
