Use a SET Fields action:
Field: your date field
Value: $TIMESTAMP$ + 7200
Remedy stores the time as UNIX epoch time (Jan 1, 1970 UTC) in seconds as a 32 bit unsigned integer. Thus to add two hours, you have to add two times the number of seconds in an hour (3600).
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Halstead, Robert
Sent: Tuesday, October 24, 2006 10:03 AM
To: [email protected]
Subject: Adding Timestamps
I was wondering if there is a way to add, say 2 hours, to a date/time field's value.
Am I going to have to tear apart the timestamp with the functions HOUR, MIN, SECOND and stuff or is there an easier way?
Bob Halstead
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
