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!
I have run into this issue. Basically the date formatting is getting tagged during your transformation process. I would guess that you are likely seeing this issue crop up on dates that meet 2 conditions:
1. The date is on day 1 to 12 of the month.
2. The date needed to have a UTC adjustment.
Are you doing this transformation in Power Query? Whats the part of the formula that sets the date? Could you change your formula to instead just add #duration(0, X, 0, 0)?
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 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!