If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Datatime into CST,PST and MT

Started by Good Friend, 14 Sep 2015 07:02:33 PM

Previous topic - Next topic

Good Friend

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.

cognostechie

Do NOT double post. I gave you the reply on your original post.