Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: RL_Boston on 04 Dec 2012 04:00:18 PM

Title: How to display Minutes/Seconds but not as Clock Time
Post by: RL_Boston on 04 Dec 2012 04:00:18 PM
Hi All,
Sorry if this is not in the correct forum folder but  I think FM is where I would be creating these settings.

Basically, my data comes to me as char (00:00:00), so I've created ETL step to convert these columns to DateTime (1900-01-01 00:00:00.000).

So in FM, I have set this column Format to TIME and it will display a time '1900-01-01 00:02:51.000' as 12:02:51. How do I make it so it displays this as the actual minutes and not as 12:02:51 AM ?

Thanks in advance!
Text only | Text with Images