Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Ohstbuckis
5 - Atom

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"

4 REPLIES 4
bpatel
Alteryx
Alteryx

hi @Ohstbuckis 

 

here is an example of how you can accomplish this!

bpatel_0-1620768673821.png

 

hope this helps

vizAlter
12 - Quasar

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)

 

vizAlter_0-1620769478012.png

 

Please mark this solved if it helps.

Ohstbuckis
5 - Atom

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

Ohstbuckis
5 - Atom

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

Labels