TimeStamp operation

[Former Member]

Hello Forum,

I have a date field as such: 11/26/12   7:05:25PM

The time above is GMT, but we are MST. How can I change the time portion to MST? I tried {Command.REQUESTTIME} -7 but that takes it back 7 days prior leaving the time as is.

Thank you in advance,

Nabilino

[abhilash_kumar]

Hi Nabil,

Use ShiftDateTime instead. So, the formula would be:

ShiftDateTime({Input_DateTime_field},"GMT,0,GMT", "MST,420,MDT")

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces