I have a question regarding the month sort order.
I am currently using the dates table function as supplied by Sam and this works great.
The issue i have is that when getting the month names, it sorts it alphabetically (See Screenshot)
I have attempted to go to the table and select the month name column and sort it by date. I then get an error as the month name does not have unique values.
What is best practice around this? Switch Statement or perhaps creating a table with all the month names in 1 column and then adding a numerical value to to sort in that order?
Thanks in advance.