Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula question - newbie

Topic Labels: Extensions
173 4
Showing results for 
Search instead for 
Did you mean: 

This is probably really stupid but my formula below is returning the opposite of what I expect. I set the Start_Date field (data type DATE) to 9/1/2022 and TODAY() is 9/30/2022. I would expect the result to be “Y” instead it comes up as “N”. What am I doing wrong? TYIA


4 Replies 4

Hi @Alex_Ma
You are comparing a string to a date. There is no need to format the Today().

IF(TODAY() > {Start Date},'Y','N')

You can also use the IS_AFTER() function as well:

IS_AFTER(TODAY(),{Start Date},

Worked great, thank you!

Thanks, that worked too