Date Compare to Current Date returning a defined value to an existing column

[Ohstbuckis]

Brand new to Alteryx and first attempt to create a workflow from an excel file.  I have a column labeled SLA Date and I want to compare to the current date (will run this daily).  I'm assuming it is an If then else function but i do not know the syntax for Current date and how to compare to dates in file as well as how to return values to empty column.

In plain English ... If SLA Date = Current Date then "Due Today" else "Past Due"

[bpatel · Accepted solution]

hi @Ohstbuckis 

here is an example of how you can accomplish this!

hope this helps

[vizAlter]

Hi @Ohstbuckis — Welcome to the Alteryx Community!

Try this solution:

FYI, the default date format is YYYY-MM-DD for Alteryx, so 1st you will have to convert your date in this format (if that's the case with your data)

Please mark this solved if it helps.

[Ohstbuckis]

Thank you so much for the information.  It is working!

[Ohstbuckis]

Thank you for the response.  Your solution helped me deal with a date issue!