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

Date Format Issue to show UTC time

Started by davidcognos, 26 Nov 2020 11:34:44 AM

Previous topic - Next topic

davidcognos

I need to show the date format YYYY/MM/DD  UTC  time in the excel. How can we show the UTC time in cognos?? And the other issue is that date format in HTML is showing correctly but when ran in excel it shows with hyphen YYYY-MM-DD instead of YYYY/MM/DD. May be casting the date column and using extract will convert to YYYY/MM/DD but how to get the UTC time in cognos reports??

davidcognos

Can somebody tell or guide regarding conversion of the time to the UTC standard in Cognos??