Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: ame on 28 Feb 2006 06:21:33 AM

Poll
Question: How to format the date?
Option 1: a votes: 0
Option 2: b votes: 1
Title: Formatting of the date
Post by: ame on 28 Feb 2006 06:21:33 AM
I created a bar chart. The axis of abscissae represents the date. The date has the format YYYY-MM-DD HH:MM:SS:mmm. I tried to change this (to YYYY-MM-DD) by editing the data format of the property settings of the x-axis as well as the diagram node member (I hope those terms are translated correctly, since I do not work with the English version).
Unfortunately both has no effect. Does anybody know how to solve this problem?
Title: Re: Formatting of the date
Post by: mikegreen on 28 Feb 2006 01:50:02 PM
What is the date-style set to? I had to set mine to something (always use Medium) before the pattern free-text entry (the bottom most option) would work.

Are you setting the property in Framework Manager or ReportStudio?
Title: Re: Formatting of the date
Post by: srivaac on 10 Apr 2006 03:40:31 PM
use the following function:

to_char([Query Item],'yyyy-mm-dd') - what this does it changes your date format at yyyy-mm-dd.

Hope this helps
Text only | Text with Images