Print Page - Changing number field with date data to show in ddmmyyyy format

Title: Changing number field with date data to show in ddmmyyyy format
Post by: gatorfe on 02 Dec 2010 03:45:49 PM

There is date field that a user added to a crosstab report as a measure and changed the data format from date to number. The format the data looks like is 20101201(yyyymmdd). The user wants it to show as 01122010(ddmmyyyy) instead. Any suggestions on how I can do this? Thanks in advance for any insight!

Title: Re: Changing number field with date data to show in ddmmyyyy format
Post by: mahgar on 13 Mar 2014 02:20:56 AM

For whoever may face the same problem.

In Data Format,
Changed it to Long, Day, Month Year, show years, month = 2digits, days = 2 digits.

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gatorfe on 02 Dec 2010 03:45:49 PM