Skip to content
This repository has been archived by the owner on Jul 25, 2021. It is now read-only.

xlsx doesn't support dd/mm/yyyy date format as source data #180

Open
wonderiuy opened this issue Jul 24, 2019 · 1 comment
Open

xlsx doesn't support dd/mm/yyyy date format as source data #180

wonderiuy opened this issue Jul 24, 2019 · 1 comment

Comments

@wonderiuy
Copy link

wonderiuy commented Jul 24, 2019

Hello, my source table has field with dd/mm/yyyy as date format and when exporting to xlsx the datatype of the filed is "string" and not "date" (this means problem when sorting that column).
If I use mm/dd/yyyy in my field the datatype is correctly recognized as "date" but not when the source field has dd/mm/yyyy content.
I would expect that the date format dd/mm/yyyy is recognized as a correct date as is.
Version 5.2.0

@wonderiuy
Copy link
Author

As today, the only plugin which support dates in dd/mm/yyyy is the hhurz/tableExport.jquery.plugin

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant