Forum Discussion
Solved
Convert YYYYMM to date
Hello, I have searched all over and I see many folks have the opposite issue. I have a date column that is YYYYMM and I need to convert it into a date the date table can recognize. When I add a c...
Figured it out - Converted the YYYYMM Column to text and then added new column and used this code.
=Date.FromText( Text.Range([Input Date as Sting], 0,4) & "-" & Text.Range([Input Date as Sting], 4,2)
)
In the meantime I was preparing an answer: in Power Query you can add suffix "01" and then change the column type to date.
let
Source = #table(type table[YYYYMM = text],{{"201709"},{"201710"}}),
#"Added Suffix" = Table.TransformColumns(Source, {{"YYYYMM", each _ & "01", type text}}),
#"Changed Type" = Table.TransformColumnTypes(#"Added Suffix",{{"YYYYMM", type date}})
in
#"Changed Type"
note that this does not work if you are outside the US region and using certain datasets - you will still need to create a date from parts