Date format in Dimension field

[#1]

Hi All,

I am importing a table from MS Access including a date field. In Access I see the date as dd/mm/yyyy

When I import it to QV I see the date as a serial number, eg 40210, 40247 etc.

That's not a major problem - I have created a list box to display all dates and just set the number format as Date - dd/mm/yyyy

However, I want to plot a chart using the date as my x-axis. So I have selected Date as a dimension, but it displays as a serial number on the chart. How do I get this to show in dd/mm/yyyy format?

Thanks for any suggestions,

Tony

[#2 · Accepted solution]

Hi,

In script change to

date(Datefield,'DD.MM.YYYY') as DateField

Regards

Sravan

[#3]

Hi,

You have to easy options. The first one is to use a Calculated Dimmension instead of the field with the date itself. For example, if the field with the date is A, use as dimmension Date(A).

The second option is to apply this change in the script instead of using on the chart when loading the data. The advantage of this solution is that you will not have to "translate" the date anymore in any other charts

[#4]

Perfect, thanks Sravan.