Print Page - Converting a date time field

Title: Converting a date time field
Post by: Joker on 03 Apr 2014 09:25:30 AM

Hi,

There is a date time field([INTRODUCTION_DATE]) in the report.The format is like (Dec 5, 2003 12:00:00 AM). I want to convert it to a format like(05122003). How can I do this?
Thanks in advance..

Title: Re: Converting a date time field
Post by: MFGF on 03 Apr 2014 09:45:30 AM

Hi,

Select the item in your report. Go to the Data Format property and select "Date" then within the same dialog set the Pattern property and enter ddMMyyyy as the pattern.

Cheers!

MF.

Title: Re: Converting a date time field
Post by: Joker on 03 Apr 2014 10:32:05 AM

Thanks a lot MFGF.
I have noticed that you have answers to all the questions related to cognos.
:D

Title: Re: Converting a date time field
Post by: MFGF on 04 Apr 2014 11:40:05 AM

Quote from: Joker on 03 Apr 2014 10:32:05 AM
Thanks a lot MFGF.
I have noticed that you have answers to all the questions related to cognos.
:D

Ha! Thank you! It's probably a good job you haven't noticed how few of them are correct answers, though ;)

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Joker on 03 Apr 2014 09:25:30 AM