+6This 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”)
+16Hi @Alex_Ma
You are comparing a string to a date. There is no need to format the Today().
IF(TODAY() > {Start Date},'Y','N')
+35You 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!
+6You can also use the IS_AFTER() function as well:
IF(
IS_AFTER(TODAY(),{Start Date},
'Y','N'
)
Thanks, that worked too
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.