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

How to display Minutes/Seconds but not as Clock Time

Started by RL_Boston, 04 Dec 2012 04:00:18 PM

Previous topic - Next topic

RL_Boston

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!