Date format

[#1]

Hi all!

I've tried to make a simple sales/year chart but I'm struggling with the dates...

I get my data from an odbc and the date format is YYYYMMDD (e.g 20120213). When I try to change the number format settings to dates the values are just nonsense...

What should I do in order to get the chart so that it would show sales/years then months and days?

Cheers!

[#2]

Thanks Ashok for the help!

I got it working

Regards

Antti