Toad World® Forums

Export to Excel : dates are exported as text and not as dates

Hi

When I export records to excel, the dates are considered as text, and I can’t sort, filter on them correctly

Dates.png

When I export them to CSV I can re-import them to excel, and then I have real dates (but other problems related to our data’s) :

Microsoft Excel - autorisations2.png

Regards

Martin

Hi Martin,

Thanks for your feedback, I find have existed a same story(SQLNAV-1916 :Date fields aren’t date format when Export data to Excel) about it, I will focus on it.

Regards

Alan