Forum Discussion
Date format and table layouts
I have a few different tables I'm hoping to link up, but the layout is slightly different. On one of the tables, there is a column that includes the date of the transactions in YYYYMM format. In the ...
benjamin_sasin
Resolver I
Resolver I
Anonymous wrote:= DATE(LEFT([OLDDATE], 4), RIGHT([OLDDATE], 2), 1)
Is this supposed to work in PowerQuery (Excel) too?
You can do something similar in Power Query. LEFT would be Text.Start. Right would be Text.End. Date isn't supported, however you can use Date.FromText to do something similar. I get the best results when i use Date.FromText and put the date data in a YYYY-MM-DD format first.