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

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"

Date Time

Accepted answers

here is an example of how you can accomplish this!

hope this helps

New Workflow2.yxmd

All comments

here is an example of how you can accomplish this!

hope this helps

New Workflow2.yxmd

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.

Date Compare to Current Date___vA.yxmd

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703