cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate difference between 2 timedate and subtract weekend hour

Former Member
0 Kudos
63

Post Author: dbennett

CA Forum: Formula

How can I accomplish this?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: yangster

CA Forum: Formula

this is the most basic of possiblitieshad you done a simple search of datediff in the crystal help you would have been given the example//Crystal syntax

Local DateTimeVar d1 := {Orders.Order Date};

Local DateTimeVar d2 := {Orders.Ship Date};

DateDiff ("d", d1, d2) -

DateDiff ("ww", d1, d2, crSaturday) -

DateDiff ("ww", d1, d2, crSunday)