Sort By Registration Date Not Working

  • First I want to say how great this plugin is! We have run into one bug though. In one of our lists we’re trying to sort users by the registration date, but it only sorts in ascending order. We can’t get it to reverse even if we change the sort order in the list settings, or we click the field heading on the frontend. Is this a known bug?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author anmari

    (@anmari)

    Hi – it’s more like a historical anomaly. Rather use the field ‘Registered days ago’ – that is actually the real ‘user registered date’, but formatted as days since registration (also shows the actual date when one hovers over the field). This was the original need. CSV should also show the actual date I think.

    The field ‘registered date’ is kinda a copy of the real field that some folks asked for because they wanted to show the date directly. This is possibly why it is misbehaving.

    The plan in the long run is to offer a choice of date/time format rather and collapse the two fields back into 1.

    Thread Starter Martin Blumenfeld

    (@monkeypress)

    Thanks! The sorting is now working. Now my only issue appears to be the actual displayed date. I have my timezone set to Vancouver in WordPress, but the registered date doesn’t appear to be obeying that. Do you know what this issue is as well?

    Thread Starter Martin Blumenfeld

    (@monkeypress)

    As an example, one of my users says the registration date was at 2017-01-10 04:21:08. I can also confirm this in the DB. In actuality, they were registered at about 2017-01-09 20:21:08 PST. The time is now 2017-01-10 16:38:12 PST, but the registration days ago value still says 16 minutes ago. It looks like the days ago code is ignoring the timezone and also the hour and is reading it date off of the minutes in the time only.

    Plugin Author anmari

    (@anmari)

    Aahh, now you really have found something.

    Wordpress is saving registered date in UTC time (as it does with post dates etc for good reasons). So when we display these dates we should be converting to the websites current timezone, not just grabbing from the DB.

    Note made and hopefully I’ll be able to roll a fix into an update soon.
    Thanks for flagging.

    Thread Starter Martin Blumenfeld

    (@monkeypress)

    Thanks! I look forward to a fix being released.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Sort By Registration Date Not Working’ is closed to new replies.