Creating Formula to track shipments

Question

I have both the Arrival Date and the Expected Date, please help me do the following.

Create the field [Flags] using these rules:
- shipments arriving within 6 days of the expected date are flagged "On Time"
- shipments arriving within 20 days of the expected date are flagged "Late"
- shipments arriving over 20 days after the expected date are flagged "Significant Delay"

Peachyco · Answer

The page that @gawa has linked above has the solution. It assumes that there is the field [Days], though.

If you don't have [Days] yet, you can calculate it by applying the DateTimeDiff() function on [Arrival Date] and [Expected Date] like so:

DateTimeDiff([Arrival Date], [Expected Date], "Days")

gawa · Answer

hi @aicastro

The same question was solved in the below post. Pls check it out.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Conditional-Rule/td-p/1231445