Convert numbers into Year and Month

I have some data that looks like this: 2203

I want the 22 to be converted to 2022 and 03 to be converted to Feb (note that it should be the prior month)

So the newly generated columns should be 2022 under Year and Feb under Month.

Updated:

Since @Qiu has asked me: for 2201, the outputs should be 2021 under year and Dec under month.

Date Time

Accepted answers

@45179902
Thank you for the confirmation.
Maybe we can do like this.

you could convert the number to a string, a the leading "century" and use DateTimeParse and DateTimeFormat to create the required date format.

I've splitted it to a 3 formulas. In the first formula, you could add a condition, if there are date from 19xx.

Let me know if it works for you.

Best,

Roland

@45179902
What will be result for 2201? 😁
Basically it will be combinations of DateTime Functions.

@Qiu That's a good question. In that case, should be 2021 and Dec.

@45179902
Thank you for the confirmation.
Maybe we can do like this.