how to use data-order

micrem73

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

allan

See this blog post for details on how to sort formatted dates.

Allan