Sorting a report by Date appears to mix 2017 with 2016 and only sorts on day/month?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Like this...

23-02-2016
25-02-2017
22-03-2017
30-03-2016

I am using DD/MM/YYYY as I live in UK

Photo of Michael Graham | Insight Global UK

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 630 Points 500 badge 2x thumb
I'm not seeing this when I tested this - with [Date] as a Date field, and the date format being DD/MM/YYYY.

i.e. the dates are sorting like this for me:

23-02-2016


30-03-2016

25-02-2017

22-03-2017

I think it'd only sort as you have it above - if it's a Text field?  It should sort correctly as a Date field.
It helps when you are not stupid... i.e. ME.
I was sorting on the wrong Date Field!    
All correct now. LOL!
Photo of Xavier Fan

Xavier Fan, Champion

  • 630 Points 500 badge 2x thumb
Hehe - glad you figured it out!