Forum Discussion
Dataflows date and import issues
Hi Xiaoxin,
So i managed to fix the dd/mm/yyyy display issue. In-case someone else comes across the same problem, it was a language setting in Chrome, I needed to specifically add the English (Australia) language and make sure it was at the top of the list and set to "This language is used to display the Google Chrome UI". Interestingly i could not get Edge to work either.
The other problems still exist, i am just waiting for some in my organisation to assist with ticket.
Thanks for your help on the display issue.
Same issue now for two months.
MS team are aware that non-US dates do not load correctly in dataflows, but as of today's advice have kicked the "fix" back to February.
Where the data source comes from SharePoint, even more issues are created due to the US date format default - but even explicitly setting the date to AU region will not resolve the error.
Latest suggested resolution was to leave all date fields as text....