Data type Change

[aish25sumbre]

Hello Everyone ,

I have date column under which I have values like 201901 ,2021902,....,202107

how to convert these values in proper date format like

2019-01

2019-02

.

.

.

2021-07.

Please help me with this

[v-eqin-msft]

Hi @aish25sumbre ,

If @amitchandak 's suggestion works for you, please kindly Accept it as the solution,More people will benefit from it. 

Below I provide another method:

Then choose the correct Format :

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@aish25sumbre , if you need date, new column

Date = date(left([column],4), right([column],2), 1)

if you need month year

year month = left([column],4) & "-"& right([column],2)

[aish25sumbre]

Thank you for help.

It works.