In most cases, customizers/administrators leave the Date & Time field as Local without paying much attention to detail.
With involvement of time, there are 2 behaviors while creating the field (or changing them, but there’s a catch)
You can change from Local to Time-Zone Independent any time, but can’t change from Time-Zone Independent to User Local once saved this way.
User Local
The Date & Time displayed in this field will be converted to the time-zone you are situated in.
Let’s say, the Date & Time is stored in UTC behind the scenes was 25th June 2019 6.30 PM, so whatever was stored, it will be converted to your System User’s local time according to the Settings. See below –
Time-Zone Independent
This type of Date & Time of field, the time is stored in UTC, regardless of where you are located in the world.
If it is 6.30 PM on 25th June in UTC, it will be 12 AM in India on 26th June
It’s pretty basic, but needs to be done carefully!
Hope this helps.
[…] Date and Time field’s Time-Zone behavior in D365 […]
LikeLike
It seems that Microsoft should allow you to set the time format in the display to allow Timezone to be included. This way when you enter your time – the format is reminding the user what they are entering. This is an easy way to help to make sure mistakes are not made.
LikeLike
Agreed. This has always been the issue in assuming what time is being shown. We have to remind ourselves what timezone we are in. Great point!
LikeLike
Hi Priyesh,
Quick question. How can I set the Time Zone globally for the entire tenancy apart from providing the user access to change their timezone through the Personalization settings?
LikeLike
Hi Mithun, you can use XrmToolBos’s User Setting utility to select all active users and change them yourself. provided you have Sys Admin privileges.
LikeLike
Hi Priyesh,
Is there no in built setting in PowerApps where we can set the Time Zone rather than setting it through CrmToolBox?
LikeLike
Nopes, there’s isn’t one as such for setting everyone’s timezone’s.
LikeLike