Forum Discussion
Help on Date Format conversion
I have 2 Excel files with a Source that has this Column 'Date' (see below) in my 1 Excel it converts fine but in the other it converts it to Month as Date and Date as month see other image below. ...
By the way I already tried using Locale but it too doesn't work my currect solution is not advisable because if the source will change it's format it will not work... Basically I split this by delimeter and added a custom column with this syntax #date() - this worked but again it's not flexible.
I just can't understand why it worked in another Excel (this was older but the same source) and did not work in my version today.
ovetteabejuela , you may want to try,
Table.AddColumn(Source, "Custom", each Date.ToText(Date.From([Date]), "MMMM d, yyyy"))Unfortunately...
and my Regional settings is fine: