Solve the Date no sequence issue

[kiansin]

Hello !!

I have a attached table as below :

The column "NewDate" was not present by sequence.

I want to order by the New Date by sequence.

For example : The expected result should be like this :

[2021 Oct

2021 Nov

2021 Dec

2022 Jan

2022 Feb

2022 Mar

2022 Apr

2022 May

2022 Jun

2022 Jul

2022 Aug

2022 Sep]

Any possible way to fulfil my requirement ? 

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

[Chandan_Nadve]

Hi @kiansin ,

Your NewDate is not in the "Date"  data type. It is in the string data type. You need to convert this to Date data type using date function.

Use the below Dimension in NewDate.

DATE(NEWDATE,'YYYY MMM')

Regards

Chandan

[kiansin]

hi @Chandan_Nadve 

My NewDate was using Inline method,

how do I able to convert this yo date data type ?

Regards,

KianSin

[sicilianif]

You can use a preceding load to convert the date:

MyDates:
Load
           Date#(Date1,'YYYY MMM') as NewDate;
Load * Inline
[
Date1
2021 Oct
2021 Nov
2021 Dec
2022 Jan
2022 Feb
2022 Mar
2022 Apr
2022 May
2022 Jun
2022 Jul
2022 Aug
2022 Sep
]