Forum Discussion
Custom datetime column inconsistent formatting
On their own they look fine. Next i'd check the 3 different locale settings and make sure they are consistant:
Set a locale or region for data (Power Query) - Microsoft SupportThank you. The data source is a Dynamics365 dataverse. The report region / locale was correctly set to Australia already however my device was using a "default" setting. I have adjusted this to specifically point to Australia instead and this seems to have fixed the issue.
Such a simple solution! Thank you again Ross for helping talk me through this issue. It is truly appreciated!
Hi Ross,
Thank you very much for taking the time to respond.
Here is precisely how the custom column is being calculated:
You are quite right that this is occurring for days 1-12 in the month.
On their own they look fine. Next i'd check the 3 different locale settings and make sure they are consistant:
Set a locale or region for data (Power Query) - Microsoft Support
Thank you. The data source is a Dynamics365 dataverse. The report region / locale was correctly set to Australia already however my device was using a "default" setting. I have adjusted this to specifically point to Australia instead and this seems to have fixed the issue.
Such a simple solution! Thank you again Ross for helping talk me through this issue. It is truly appreciated!