Time addition for Remedy fields 1

[winstonep]

This one is proving difficult to resolve even though it should be simple.

Using Crystal Reports 9, I'm trying to calculate a target date and time for a Remedy case resolution. I need to be able to calculate depending on the contents of the Priority field, what the target will be.

So for priority 1 calls, there are no business hours/holiday restrictions. Therefore it should just be the date/time + 8 hours. So for example, if I assume the datetime string is:-

"01/07/2003 18:00:00"

The datetime result should be, "02/07/2003 02:00:00".

Nothing I have tried so far has been able to add 8 hours to a datetime field. I don't want to have to go to the level of breaking the date/time down into its components as this will be so much hassle.

Any help or advice on this date manipulation question is appreciated!

 

[rosemaryl]

Dear Winstonep,

I am not familiar with Remedy date-time fiels but you should be able to use the Dateadd function:


DateAdd ("h",8 ,{Your Date Time Field} )

Hope that helpse,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[winstonep]

Thanks Rosemary. That's just what I was looking for.