1 of 1 people found this helpful
Convert it to a string and reorganize it the way you need. Once it looks the way you want then wrap it in a DATE function and it will be good to go.
Whilst this works, I'm still curious why it is only affecting some columns.
For this answer, you will probably have to look at how the data is stored in the database and may also look to location settings of the server on which it resides.