Format from yyyymm to mm.yyyy

[Jeyaraj_M]

Hi Team,

Need a quick help

i am trying to convert the format in a column from yyyymm to mm.yyyy when i try to convert the output i am getting as mm.yy and not as mm.yyyy

i tried this formula DATETIMEFORMAT(DATETIMEPARSE([Calendar Month/ Year],'%Y%m'),'%m.%y')

My source is as below

Calendar Month/Year

202002

202002

202002

202005

202006

202007

Expected output should be as follows

Expected Result

02.2020

02.2020

02.2020

05.2020

06.2020

07.2020

[ImadZidan · Accepted solution]

Hello @Jeyaraj_M ,

Something like this?

have a look. I hope it helps.

[bhrmitra · Accepted solution]

Hi  Jeyaraj_M,

Using a the formula will give you the desired result 

Formula - DateTimeFormat(DateTimeParse(ToString([Calendar Month/Year]),"%Y%m"),"%m.%Y")

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra