Forum Discussion
ovetteabejuela
Impactful Individual
Impactful IndividualHelp 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. ...
CNENFRNL
Community Champion
Community Championovetteabejuela , you may want to try,
Table.AddColumn(Source, "Custom", each Date.ToText(Date.From([Date]), "MMMM d, yyyy"))
ovetteabejuelaImpactful Individual
Impactful IndividualUnfortunately...
and my Regional settings is fine: