Forum Discussion
Converting US date/time text to EU date format
I receive a spread sheet each month from 3 different world areas. I store these in a Sharepoint folder and then combne them in PowerBi so that i end up with one global repprt. The spreadsheets contain raw data and are not manipulated in any way. The report I get from the US has a Date/Time field. When i open it in PowerBi it sees it as text in the format MM/DD/YYYY HH:MM. When i convert that field to Date / Time it gives me an error for any field where DD is bigger than 12. It's obviously not realising teh date is in US format. Any suggestions?
When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent.
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).
1 Reply
When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent.
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).