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
Date
Votes
1 comment
-
Jet Reports Historic Posts Would "hide+?" in connection with
if(Yourfield>2;"Show";"Hide")as described here http://kb.jetreports.com/article/AA-00522/0/ work for you?
Cheers
André
Please sign in to leave a comment.