COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: philman2006 on 25 May 2007 02:06:29 PM

Title: Format General Field to Time.
Post by: philman2006 on 25 May 2007 02:06:29 PM
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!!!
Title: Re: Format General Field to Time.
Post by: COGNOiSe administrator on 26 May 2007 07:55:23 PM
Just brake it apart using Mid and construct new time (or string) from the parts.