0

Display only the lines that meet a condition

My report is displaying sales orders and calculating number of days late using the order date and posted sales shipment date. I only want to see orders greater than 2 days late in the report. I used the date function DATEDIF to calculate the difference between order date and Posted sales shipment date. Most of the values are 0, 1 and 2 which are considered on time shipments. How do I get the report to display only the sales orders >2 days late?

Thank you,

Jackie

1 comment

Please sign in to leave a comment.