Afternoon all,
I have found a strange thing here, I am using datediff to find out the number of days a job has taken to be shipped.
I found out that Crystal report does not include the date (day of order) and counts from the next following day.
Example
Order placed = 25/06/2008
Order Shipped = 27/06/2008
Days took = 2 (According to Crystal)
However,
According to our old system the same job took 3 days
Order placed = 25/06/2008
Order Shipped = 27/06/2008
Days took = 3 (According to our old system)
How can I make the Crystal count the order day as well!??
many thanks
Kind Regards
Jehanzeb