Support » Plugin: Inline Google Spreadsheet Viewer » Sorting not working with our date format

Sorting not working with our date format

  • keengamer

    (@keengamer)


    10 months, 1 week ago

    Hello,

    we use google forms which are then loaded into the google sheet. The date and time format cannot be changed and it is for example like this 10.3.2020 11:08:20. And in this case the sorting of the table is not working on our site.

    For example sorting from the newest one shows first:
    8.1.2020 13:59:50 and then
    7.7.2019 11:31:25

    But February and March is somewhere at the bottom of the table.

    Is this something we can fix on our end or is it something you must do?

    Thank you.

Viewing 1 replies (of 1 total)
  • keengamer

    (@keengamer)

    10 months, 1 week ago

    Edit: even if we change in the table the format to date like 8.1.2020 only, it still does not work. It sorts like this:

    1.11.2019
    1.8.2019
    10.12.2019

    However, for us, first number is the date and second is the month. But it should take first year, then month, then date.

Viewing 1 replies (of 1 total)
  • The topic ‘Sorting not working with our date format’ is closed to new replies.

Views