Forum Discussion
ranz_vincent
Helper I
Helper IHaving problems with multiple date formats after last refresh
Hello I suddenly encounter a problem with date format after my last data refresh and I have been using this model since January 2025 and now all of a sudden my date columnns are saying that there are...
Hi ranz_vincent
When changing the data types, especially at the very beginning, always ensure that the culture is specified. Also, if you have any transformations that combines the date with another column, specify the culture as well.
en-AU and en-GB follows dd/mm/yy while en-US follows mm/dd/yy.
danextian
Super User
Super UserHi ranz_vincent
When changing the data types, especially at the very beginning, always ensure that the culture is specified. Also, if you have any transformations that combines the date with another column, specify the culture as well.
en-AU and en-GB follows dd/mm/yy while en-US follows mm/dd/yy.