Y axis dates displayed as numbers instead of Dates

[#1]

Hello,

I have a line chart. both x and y axis are dates.

I have 6 expressions that calculates dates.

In the number tab, I have set them to be Date format.

Here is the problem:

Only when the select is made in such a way that only first expression is displayed, the Y axis is displayed in date format mm/dd/yy

when i change selections to display from 2 to 5 expressions, dates are displayed as number like 41132 and not dd/mm/yy.

am not sure as why Y axis is displayed as number(41132) instead of date in mm/dd/yy.

Please advise

[#2]

Hi,

Can you please attach the QVW file

[rahulgupta · Accepted solution]

Hey hi,

In this case you can use the num() function instead of defining the format in the Number Tab.

Example:

=num(max(Date),'DD/MM/YYYY')

Hope this works...!!

[#4]

Thank you Rahul