How to sort timestamp with MM-DD-YYYY HH:MM?

How to sort timestamp with MM-DD-YYYY HH:MM?

Chapter3ofmylife10262015@gmail.comChapter3ofmylife10262015@gmail.com Posts: 7Questions: 5Answers: 0
edited December 2015 in Free community support

I want to sort a timestamp with MM-DD-YYYY HH:MM.

As I sort the column I want it to render results like this:

December 04 2015 6:32 AM

December 04 2015 6:34 AM

December 04 2015 6:35 AM

or

December 04 2015 6:35 AM

December 04 2015 6:34 AM

December 04 2015 6:32 AM

Thank you in advance

Jason :)

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 62,998Questions: 1Answers: 10,371 Site admin
    Answer ✓

    Have a look at this blog post which details how this might be done.

    Allan

  • zachpainter77zachpainter77 Posts: 22Questions: 1Answers: 1

    You could store the time in a hidden column and use it as a secondary sort, maybe?

This discussion has been closed.