Hello All,
In Framework manager I have a data item "date", it is in date-time format and i'm trying to write a case statement in FM to convert into below format based on the time zone. Date is defaulted to Eastern time and i'm unable to do a minus -1 or -3 as below.
(datetime -1) (Datetime is in EST and in format AUG 26, 2015 11:31:03 PM), Expected Result : AUG 26, 2015 10:31:03 PM (To get result in CST)
(datetime -3) (Datetime is in EST and in format AUG 26, 2015 11:31:03 PM), Expected Result : AUG 26, 2015 08:31:03 PM(To get result in PST)
Is there anyway to get the desired result for the above as i failed to get it.
Thanks.
Do NOT double post. I gave you the reply on your original post.