I have been trying to sort a particular table by date with no success. I would to sort the rows by date - newest to oldest - and then by name (A-Z). At the moment it is either sorting it by day (i.e. the highest day in the month is shown first regardless of month) or if I try changing the format of the date in WPDataTables settings and making the Google Spreadsheet the same format, all dates within August will display as blank.
I am using a Google Spreadsheet for the data.
Hope that is clear enough, if I can make it the question/problem any clearer please let me know.
The solution you proposed worked until October. It appears the table is taking the 1 from 10 (October) and putting that to the oldest date. Do you know how I could resolve this?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here because this ticket is private and nobody can see it except us.
Hi,
I have been trying to sort a particular table by date with no success. I would to sort the rows by date - newest to oldest - and then by name (A-Z). At the moment it is either sorting it by day (i.e. the highest day in the month is shown first regardless of month) or if I try changing the format of the date in WPDataTables settings and making the Google Spreadsheet the same format, all dates within August will display as blank.
I am using a Google Spreadsheet for the data.
Hope that is clear enough, if I can make it the question/problem any clearer please let me know.
Thanks,
Paul
Hi PauloCot,
Could you please send me spreadsheet link so I can take a look. If you have concerns about privacy you have option to mark your respond as private
Hi PauloCot,
Please change date format in your google spreadsheet to
9/26/2008
You can do it by selecting that column value and go to
Format -> Number -> Date
This is small bug that are caused by adding time and datetime column types ine the newest version of our plugin and we will fix it as soon as posible
Thanks for the time Miljko, have it working now. Cheers.
Hi PauloCot,
I'm glad to hear that it's working now. If you have any more questions, please do not hesitate to ask.
Hi Miljko,
The solution you proposed worked until October. It appears the table is taking the 1 from 10 (October) and putting that to the oldest date. Do you know how I could resolve this?
Thanks, Paul
Hi PauloCot,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here because this ticket is private and nobody can see it except us.
Hi PauloCot,
Please check it now. It should work as you desire.
I just select all dates in that column and change it to
That's awesome, thanks Miljko. Thought i kept the format consistent but clearly not, thank you for the clarification.