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

Formatting of the date

Started by ame, 28 Feb 2006 06:21:33 AM

Previous topic - Next topic

ame

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?

mikegreen

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?

srivaac

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