Skip to Content
0
Sep 21, 2023 at 01:38 PM

late order report including items not late

38 Views

Here is the formula I am using, but I am pulling in dates where the order is due say 7/7/23 but the ship date was 6/30/23. What am I missing? it also keeps removing the first set of grouping parentheses that groups lines 1 and 2.

({Delivery.Shipped_Date} = (YearToDate) and

{Delivery.Promised_Date} = (YearToDate)) and

({Delivery.Shipped_Date} > {Delivery.Promised_Date} or

(currentdate) > {Delivery.Promised_Date})