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. ...
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: