Formula for adding additional hours - Forecasting 1

[rico7937]

I am using Crystal Reports v10.

I am trying to create a formula that will let me forecast when a Service Desk Ticket will breach based upon severity.

SEV 1 4 HRS
SEV 2 24 HRS
SEV 3 10808 HRS(7 DAYS)

Ex. Sev 1 Ticket opened 6/30/2008 1:00:00 PM should breach at 6/30/2008 5:00:00 PM

Currentyl I am using this formula to convert it to EST:

DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEMS.OPEN_DATE},{PROBLEMS.OPEN_TIME}),"MM/dd/yyyy hh:mm:ss tt"),"Eastern Standard Time"))

Now I am trying to figure out how to add this command to go along with it:

dateadd("h",4,datetime({PROBLEMS.OPEN_DATE},{PROBLEMS.OPEN_TIME}))

So I need both in one formula statement if possible.

I just need the addtional time added on to the open date & time to help me forecast the breach time. Any suggestion would be greatly appreciated.

 

[lbass]

Couldn't you just use:

dateadd("h",4,{@converteddt})

...where {@converteddt} is your conversion formula?

-LB

 

[rico7937]

Thank you, that worked !