Re: IF-formula - IF today then

1325 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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?


2 Replies 2


Instead of

dateField = TODAY()



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!