Skip to Content
0
Former Member
Jul 22, 2008 at 12:28 PM

Count the days Crystal!!

199 Views

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