Help

Formula question - newbie

Topic Labels: Extensions
590 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Ma
6 - Interface Innovator
6 - Interface Innovator

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

IF(DATETIME_FORMAT(TODAY(),“MM/DD/YYYY”) > Start_Date, “Y”, “N”)

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:

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

Worked great, thank you!

Thanks, that worked too