Forum Discussion
Solved
Errors when changing data type to Date
I wonder if anyone can help. I have just noticed after importing a whole load of data from excel, that PBI is converting my date information to US format when the month is greater than the day. The ...
Hi carlbh,
Assuming that all the dates are formatted the same way (day/month/year) you could use this code to create a custom column:
New_Date = DATE(RIGHT([date],4),MID([date],3,6),LEFT([date],2))
You can change the datatype of New_Date to date.
Kind regards,
I literally created an account just to thank you!