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

Format General Field to Time.

Started by philman2006, 25 May 2007 02:06:29 PM

Previous topic - Next topic

philman2006

Is there an easy way to change a field format from General to Time?  I have tried all the Functions and nothing works.  For instance the time is 025032 (02:50:32 PM)  I am new at using Impromptu.

Thanks!!!

COGNOiSe administrator

Just brake it apart using Mid and construct new time (or string) from the parts.