Year and Month Format - YYYY_MM

[sk88024]

 Hi All,

I have a requirement where the following Date Field (contains Year and Month only) needs to be converted into YYYY_MM format. Can somebody please advise on this. I have tried few options form my side but they are not giving the expected output. 

Input YearMonth	Output YearMonth
2019_3	2019_03
2020_1	2020_01
2019_10	2019_10
2019_11	2019_11

The transformation is highlighted in blue/bold in Output YearMonth.  

Thank you!

Regards,

SK

[Taoufiq_Zarra · Accepted solution]

Hi,

Maye be ;

Date(Date#([Input YearMonth],'YYYY_MM'),'YYYY_MM') as [Output YearMonth]

output :

[sunny_talwar]

May be this

Date(MakeDate(SubField(YearMonth, '_', 1), SubField(YearMonth, '_', -1)), 'YYYY-MM') as YearMonth

[sk88024]

Thanks Taoufiq. It worked. I was missing the second YYYY_MM in my trials. 

Regards,

SK