We recently switched to a new Crystal Enterprise Server that doesn't support the CA PDM date time functions.  Since i can no longer use the datetimediff function, this presents a problem when I am trying to do a duration formula to see how long a ticket was open. Does anyone know of another formula I can use to see the time difference between the open date/time and close date/time?

The date formula I am using is:

DateTimeVar UTC:= DateAdd ('s' , {call_req.open_date} , Datetime (1970,1,1,0,0,0));

DateTimeVar EST:= DateAdd ('h' , -5 , UTC);

If EST in DateTime (year(EST),3,8,2,0,0)  to DateTime (year (EST),11,1,0,59,59)

                then DateAdd ('h' , 1 , EST)

else  EST

The call_req.open_date is the database field for the open date of the ticket.

Thank you!

DateAdd??? I would think that you want DateDiff, so that you get the number of seconds from 1/1/1970, after that, I think that the rest of the logic is fine.

have you tried: DATE("4/9/2014") ?

it should work according to documentation...then you could use DATEADD