Converting a Date Format to another

[amrutha_sathish]

I have a field Named Month in the format of 202304 (YearMonth).

So how do i convert it into the format 'Apr-23'.

Thanks in advance.

[Oleg_Troyansky · Accepted solution]

Something along these lines:

Date(date#(OldMonth, 'YYYYMM'), 'MMM-YY')

[BrunPierre · Accepted solution]

One way could be this.

Date(Date#(YearMonthField,'YYYYMM'),'MMM-YY')

[Oleg_Troyansky]

Jinx!

[amrutha_sathish]

Thank you! It worked!! 😊

[amrutha_sathish]

Thank you! It worked 🤗

[simsa]

Date(Date#('202303','YYYYMM'),'MMM-YY')