Hi there,

I have an On-Time report that used to be very simple, the formula for the late field reads as:

if {@Ship Date Only} > {@Promise Date Only} then "Yes" else "No"

the {@Ship Date Only} and {@Promise Date Only} are DATE fields.

But now we have a customer that sends us requirements through EDI. Their Promise dates are usually on Mondays, but their truck doesn't show up until Tuesday.


I want to keep the formula above because it's working for all other customers. but i want it modified to include the argument of:

when {ARCUSTO.CUSTNO} = "BOGRMET" and the difference between the ship date and the promise date is 1, then it should be a "No".


I hope this makes sense.

Thank you

I think this worked.

I will do more testing and see.

Thank you so much!

I think I made it work..

if {ARCUSTO.CUSTNO} = "BOGRMET" then
(if {@Ship Date Only} - {@Promise Date Only} <= 1 then "No" else "Yes") else
if {@Ship Date Only} > {@Promise Date Only} then "Yes" else
if {@Ship Date Only} > {@Promise Date Only} then "Yes" else "No"