IF-formula - IF today then


#1

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!


#2

@Eivind_Augum

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.


#3

Thanks, worked perfectly!