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!