Issue in Date sorting.

[fcafra]

Hi, i store into my db this format for my date YYYYMMDD so i use DATE_FORMAT(AD01,'%d/%m/%Y') in my query because i would see a better view to y axes. But the sorting date is string and the sort is not work wery well. it's a way to sort correctly ?

Sorry for my dab english.