Date appearing in 2 different formats

[anonymous1]

hi, 

could anyone please tell me why the date is appearing in 2 different formats?

i have created a calendar on this date but when i select it for a list box it appears as expected, but when i select it for a straight table its appearing as a number. how can i get it to appear as the date?

[martinpohl · Accepted solution]

Hi,

you use an expression in your chart, so the value of a date is numeric.

You can set the display formatting under the tab numbers or edit the expression to 

date(yourexpression)

Regards