how to use data-order
how to use data-order
micrem73
Posts: 2Questions: 2Answers: 0
Hi,
I'm a wordpress user using "Inline Google Spreadsheet Viewer", that makes use of DataTable to convert a Google Sheet file in a HTML table to be publiched on a page. It allows to define all DataTable setting, and I think there is the solution to my problem.
A column of my sheet contains dates in european format, like DD-MM-YYYY.
When i sort the column in the resulting table, of course the sort is made incorrectly. I see the data-order function in documentation, but still I can't figure out how to use it. I suppose i could add a column in the sheet, auto calculate a timestamp for each date, with the aim of using that data as sorting source. But, what i miss is the CSS or other setting of DataTable to achieve that.
regards
michele
This discussion has been closed.
Answers
See this blog post for details on how to sort formatted dates.
Allan