Creating Formula to track shipments

[aicastro]

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"

[gawa]

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

[Peachyco]

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")