Date Format While Exporting Report To CSV

[arroju_venkat]

In a report date field is in YYYY-MM-DD format and when the report is run in HTML format format appears as YYYY-MM-DD but when the report output is exported to CSV ,date format seems to change i.e displaying DD-MM-YYYY rather than YYYY-MM-DD
Any ideas how to make the format constant in both the format

[Suraj]

Did you try setting Format as Date and specify the ordering?
It gives me same format in html and excel when I set those formats.