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??
Can somebody tell or guide regarding conversion of the time to the UTC standard in Cognos??