Sorting by UK date

  • Resolved simonjamesuk

    (@simonjamesuk)


    1 year ago

    Hi, I have a table with training course dates in it, and I would like to auto-sort the list in date order when the page loads. I am using the UK date format dd/mm/yyyy.

    I have read other threads on here with similar issues, but I have not yet been able to be able to fix it on my site. I’ve tried using the syntax columnDefs in the “Table Features for Site Visitors” section, but I don’t seem to be able to get it to work. Any help would be appreciated.

    Many thanks.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter simonjamesuk

    (@simonjamesuk)

    FYI, below is the syntax I’m currently using:

    “columnDefs”: [ { “type”: “date-eu”, “targets”: [ 2 ] } ], “order”: [ [ 2, “asc” ] ]

    It sorts the column, but only in day (dd) order, and I’m trying to sort the whole date. Many thanks!

    Thread Starter simonjamesuk

    (@simonjamesuk)

    OK, i think i have fixed this by installing the ‘DataTables Sorting plugins’ extension.

    Thread Starter simonjamesuk

    (@simonjamesuk)

    Final question, is it possible to automatically hide dates in the past (i.e. expired events)?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi!

    Thanks for your post and sorry for the trouble!

    Indeed, installing the TablePress DataTables Sorting plugins Extension is the solution here, together with that “Custom Command”. Good to hear that you found this already! ??

    As for hiding rows with dates in the past: This is possible with the Row Filtering feature module that is part of the TablePress premium versions, which provides the basic functionality for this. So, if upgrading to TablePress Pro or Max would be an option for you, I’ll be happy to provide the necessary code and instructions for this, as part of the included direct priority email support that comes with the premium versions.

    Best wishes,
    Tobias

    Thread Starter simonjamesuk

    (@simonjamesuk)

    Hi Tobias,

    Thank you for coming back to me. I am a Pro customer and have the Row Filtering module enabled. Please send over the code and I’ll have a go.

    Many thanks.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ah, my bad, I hadn’t realized that. Sorry.

    Can you then please get in touch via the email address from the “About” screen of TablePress on your site? (I’m not allowed to directly provide support for the premium versions here, per the forums rules. Thanks for your understanding!)

    Best wishes,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Sorting by UK date’ is closed to new replies.