Adding 1 hour to AAC_EVENT.TIME_STAMP

[gshadz37]

Hello,

I'm looking for a way to add 1 hour to our time formula in the Sign-On/Idle report in CE because the ACD is in CST, and our agent group is in EST. The formula in its current form is:

DayTime({AgentSignOnOff_Element.AAC_EVENT.TIME_STAMP})

Has anyone come across this before?

Thanks!

 

[Sandman83]

The timestamp field is just a number, so you can add directly to it.

DayTime({AgentSignOnOff_Element.AAC_EVENT.TIME_STAMP} + 10000)

should do the trick.