Sort the Date by sequence not working

kiansin · ‎2022-07-21

Hello !!!

This table has a column called "NewDate1"

as you can see its data inside was not by sequence

My expected result should be like :

2021 Oct
2021 Nov
2021 Dec

2022 Jan

2022 Feb

and so on .....

I have already created an inline table as below :

I want the NewDate1 showing by sequence instead of randomly show out

Do you know how should I do this please? Thank you very much in advance. Cheers!

hic · ‎2022-07-21

You need to interpret the string as a date when you load it. For example

Load Date#(Date1,'YYYY MMM') as Date1, ...

Then each value will get both a textual and a numeric representation, and the numeric will be used for sorting.