Forum Discussion

MMC16's avatar
MMC16
New Member
4 years ago
Solved

Date failure

Hi all,    I have an unsual error which I am wracking my brain to try to fix, but cannot.  As most spurious issues, I haven't made any changes and it just started happening randomly today.    Da...
Need Help
  • edhans's avatar
    edhans
    4 years ago

    Convert to date using the Locale option.

     

    Your formula would look like then when you press OK.

    = Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-BM")

    Pick the correct locale for your data source, but Bermuda/English will work for dates in those formats.

edhans's avatar
edhans
Community Champion
4 years ago

Convert to date using the Locale option.

 

Your formula would look like then when you press OK.

= Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-BM")

Pick the correct locale for your data source, but Bermuda/English will work for dates in those formats.