Forum Discussion
Solved
Mixed date formats
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 ...
Thanks !
I will try that - I seem to have a lot fewer options than you do
It's still giving me a negative count of days between 06/12/2023 and today. I'm getting -133 instead of about 44
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