Skip to main content

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”)

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'
)

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')

Worked great, thank you!


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


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


Thanks, that worked too


Reply