Formula question - newbie

[Alex_Ma]

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

[Vivid-Squid]

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

[ScottWorld]

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

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

[Alex_Ma]

Worked great, thank you!

[Alex_Ma]

ScottWorld:

a

Thanks, that worked too