50
Hello All, very simple calculation but any idea why I am getting this discrepancy for some dates and not for most. Discrepancies in red.
When I calculate in Excel and other calculators online it increases by 1 date for 3 records. In dynamics I am using Calculated field AddDays function, adding 60 days to a date
Thank you Henry for educating me on this. Now I get it.
Hi Karla, that fixed the problem. Thank you so much.
Thanks Emanuel,
Behavior: User Local + Format : Date Only actually means that the date is displayed as date field, but it still contains a hidden time part in the user time zone, set to 00:00:00.
So if I set today's date in that field, I will see 2020-11-20. But it will in fact as store it as 00:00:00 my time zone (say CET).
In the system DB, it will be stored in UTC, so 2020-11-19 23:00:00 hence potentially displayed as the day before for some users in earlier Time Zone.
I suspect calculated fields take the UTC value, so potentially with day difference in some situations (user setting the date from a different Time Zone, daylight savings...)
This article covers the various Date/Time behavior: Working with Time Zones in the Common Data Service | Microsoft Power Apps
One way to mitigate this, would be to change the behavior to Date Only (if that's indeed what you're trying to capture) - that's not reversible though.
Henry
I recently learned that the Behavior set to User Local can wreak havoc on date-only fields. You have it displaying as Date Only (the format setting) but it's saved in the database as date/time.
I had a similar situation and after I updated the Behavior to Date Only my problem went away.
Hi Henry,
Both fields are date only.
Date Type : Date and Time
Field Type : Simple
Behavior: User Local
Format : Date Only
IME Mode : auto
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
