Dates in DD-MMM-YY format rather than Number

[#1]

I have attached the simple qvw file and I am trying it to show date in x- axis in 'DD-MMM-YY' form rather than number. And i want it to be continuous variable. Is there a way to format the x- axis field to show the date in regular format keeping everything the same?

[JonnyPoole · Accepted solution]

Yes - go to the number tab of the chart properties. Select the 'continuous x axis  field and change the format to date. Edit the date pattern to DD-MMM-YY on the right.

[#3]

Hi,

Try to change it in the calculated dimension

date(yourdate,'DD-MMM-YY')

[#4]

I tried this but it didn't work. Thanks for the reply

[#5]

It works. Thanks for the reply.