Forum Discussion
BrianDunk
Qrew Cadet
If(isnull([Actual Arrival Date] and today() < [Appointment Date], "Pending",
[Actual Arrival Date] <= [Appointment Date] + minutes(30) or [Actual Arrival Date]>= [Appointment Date] + minutes(30), "On Time",
[Actual Arrival Date] > [Appointment Date] + minutes(30) or [Actual Arrival Date] < [Appointment Date] - minutes(30), "Late",
isnull([Actual Arrival Date]) and today()>[Appointment Date], "No Show")
------------------------------
Brian Dunk
------------------------------
[Actual Arrival Date] <= [Appointment Date] + minutes(30) or [Actual Arrival Date]>= [Appointment Date] + minutes(30), "On Time",
[Actual Arrival Date] > [Appointment Date] + minutes(30) or [Actual Arrival Date] < [Appointment Date] - minutes(30), "Late",
isnull([Actual Arrival Date]) and today()>[Appointment Date], "No Show")
------------------------------
Brian Dunk
------------------------------
MikeTamoush
2 years agoQrew Commander
Sorry. Use Now() instead of Today() for date/time.
If(isnull([Actual Arrival Date] and now() < [Appointment Date], "Pending",
------------------------------
Mike Tamoush
------------------------------
If(isnull([Actual Arrival Date] and now() < [Appointment Date], "Pending",
------------------------------
Mike Tamoush
------------------------------
- BrianDunk2 years agoQrew CadetOk tried that and now getting this:
------------------------------
Brian Dunk
------------------------------- MikeTamoush2 years agoQrew CommanderSorry, I copy/pasted too fast and didn't notice you were missing a parentheses. The isnull statement needs a close parentheses. I accidentally left it off in my original response too.
If(isnull([Actual Arrival Date]) and now() < [Appointment Date], "Pending",
------------------------------
Mike Tamoush
------------------------------- BrianDunk2 years agoQrew CadetOk I did get rid of the errors. Now in testing it seems that "Pending" and "No Show" work with no value in the "Actual Arrival Date" Field. However, I cannot get the "On Time" and "Late" to work by the rules provided: See below image:
With these dates status should be "Late".
Brian
------------------------------
Brian Dunk
------------------------------