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

Converting a date time field

Started by Joker, 03 Apr 2014 09:25:30 AM

Previous topic - Next topic

Joker

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..

MFGF

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.
Meep!

Joker

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

MFGF

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.
Meep!