Mixed date formats

[SuzanneSte]

Hello,

I haven't found the answer I need within previous questions.

My pc is set to European date format dd/mm/yyyy.  A lot of my data is in US format mm/dd/yyyy.  I did find the setting to change Type and Locale within Power Query Editor. Having applied that though it is giving me errors on saving.   When I had managed to save that change with a subset of the data, my issue was when using the DateDiff function, Today was still being seen as European format.  I came across the previously given advice to use the Format fuction to change Today to US format.  I cannot however figure out where to use that though so that it impacts my DateDiff column correctly.   Would appreciate your guidance

[mlsx4]

Hi @SuzanneSte 

You may change the option Use default Windows Language.

[SuzanneSte · Accepted solution]

Thanks !

I will try that - I seem to have a lot fewer options than you do 

[SuzanneSte]

I found another location for chaning the locale to US - it worked !!!!  Thank you 🙂 

[mlsx4]

That's nice!! You're welcome 😊

[SuzanneSte]

It's still giving me a negative count of days between 06/12/2023 and today.  I'm getting -133 instead of about 44 

[mlsx4]

Then, I suggest you to reorder the date in power query by splitting it in three column and later on, concatenating it in the correct order