COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Rampersadpop on 19 Mar 2015 01:06:07 PM

Title: how to convert number to date format in cognos report studio
Post by: Rampersadpop on 19 Mar 2015 01:06:07 PM
Hello all,

Can someone help me out please?  :'(  i have a oracle database thats has field name 'orderdate' but the format is number. now im want to convert the number format to date in cognos report studio. what can i do ?
Title: Re: how to convert number to date format in cognos report studio
Post by: Zimbo_African_1980 on 19 Mar 2015 01:48:12 PM
Hie,
I had a similar issue,
Try one of the options on this thread:

http://www.cognoise.com/index.php?topic=2879.0

Let me know if you need more help