How to use Less/greater than or equal to condition with dates

[Saravanan13]

Hello,

I am looking to get the below output and condition is if datetimetoday is equal to date and if datetimetoday is greater than date then the status="add" else its should be as it is.Can anyone help. I am get numeric values for status if I use "If else" condition

Input

Account	Date	Status	Today
A	3/9/2024	Need	3/11/2024
B	3/12/2024	Need	3/11/2024
C	3/11/2024	Need	3/11/2024

Output

Account	Date	Status	Today
A	3/9/2024	add	3/11/2024
B	3/12/2024	Need	3/11/2024
C	3/11/2024	add	3/11/2024

[cjaneczko · Accepted solution]

If your fields are Date fields the following formula should work. You may be getting an error because the dates are not setup as Date Fields in Alteryx and could be Strings. 

if [Today] >= [Date] then 'add' else [Status] endif

If the Date fields are strings you can update them to Date with the following Formula.

DateTimeParse([Date],'%m/%d/%Y')

[JosephSerpis · Accepted solution]

Hi @Saravanan13 you need to convert your date into a YYYY-MM-DD format to use greater or less than operations however you can do this all in a single formula.