Specify time zone settings for a user
Use the UserSettings table to specify time zone settings for a user in Microsoft Dataverse. The following columns are exposed for the UserSettings table related to time zone. All time zone columns in the UserSettings table are of Integer data type.
| Column name | Description |
|---|---|
TimeZoneBias |
Local time zone adjustment for the user. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneCode |
Local time zone code for the user. For a list of time zone code values supported in Dataverse, use the TimeZoneDefinition.TimeZoneCode column. The TimeZoneDefinition.StandardName column stores the standard names of the corresponding time zone codes. More information: Time Zone tables |
TimeZoneDaylightBias |
Local time zone daylight adjustment for the user. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneDaylightDay |
First, second, third, fourth, or fifth occurrence of a day in a month when daylight takes effect for the user as per the local time zone. The day and month values are taken from the TimeZoneDaylightDayOfWeek and TimeZoneDaylightMonth columns respectively to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.For example, for the US Eastern Standard Time (EST) time zone, consider the following column values: - TimeZoneDaylightDay: 2 //Denotes second occurrence- TimeZoneDaylightDayOfWeek: 0 //Denotes first day of the week (Sunday)- TimeZoneDaylightMonth: 3 //Denotes 3rd month (March)This implies that the daylight takes effect on 2nd Sunday of March, which is effectively March 8, 2015. |
TimeZoneDaylightDayOfWeek |
The day of the week (Sunday=0, Monday=1,…) in a month when daylight takes effect for the user as per the local time zone. The month value is taken from the TimeZoneDaylightMonth column, and used along with the TimeZoneDaylightDay column value to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.See the example in the TimeZoneDaylightDay column. |
TimeZoneDaylightHour |
Hour when daylight time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneDaylightMinute |
Minute when daylight time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneDaylightMonth |
The month (January=1, February=2,…) when daylight takes effect for the user as per the local time zone. Used along with the TimeZoneDaylightDay and TimeZoneDaylightDayOfWeek columns to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.For example, for the US Eastern Standard Time (EST) time zone, consider the following column values: - TimeZoneDaylightDay: 2 //Denotes second occurrence- TimeZoneDaylightDayOfWeek: 0 // Denotes first day of the week (Sunday)- TimeZoneDaylightMonth: 3 // Denotes 3rd month (March)This implies that the daylight time takes effect on 2nd Sunday of March, which is effectively March 8, 2015. |
TimeZoneDaylightSecond |
Second when daylight time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneDaylightYear |
Local time zone daylight year for the user. Is set to 0 to indicate every year. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneStandardBias |
Local time zone standard time bias for the user. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneStandardDay |
First, second, third, fourth, or fifth occurrence of a day in a month when standard time takes effect for the user as per the local time zone. The day and month values are taken from the TimeZoneStandardDayOfWeek and TimeZoneStandardMonth columns respectively to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.For example, for the US Eastern Standard Time (EST) time zone, consider the following column values: - TimeZoneStandardDay: 1 //Denotes first occurrence- TimeZoneStandardDayOfWeek: 0 //Denotes first day of the week (Sunday)- TimeZoneStandardMonth: 11 //Denotes 11th month (November)This implies that the standard time takes effect on 1st Sunday of November, which is effectively November 1, 2015. |
TimeZoneStandardDayOfWeek |
The day of the week (Sunday=0, Monday=1,…) in a month when standard time takes effect for the user as per the local time zone. The month value is taken from the TimeZoneStandardMonth column, and used along with the TimeZoneStandardDay column value to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.See the example in the TimeZoneStandardDay column. |
TimeZoneStandardHour |
Hour when standard time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneStandardMinute |
Minute when standard time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneStandardMonth |
The month (January=1, February=2,…) when standard time takes effect for the user as per the local time zone. Used along with the TimeZoneStandardDay and TimeZoneStandardDayOfWeek columns to determine the effective date. System calculated based on the time zone specified for the user in the TimeZoneCode column.For example, for the US Eastern Standard Time (EST) time zone, consider the following column values: - TimeZoneDaylightDay: 1 //Denotes first occurrence- TimeZoneDaylightDayOfWeek: 0 // Denotes first day of the week (Sunday)- TimeZoneDaylightMonth: 11 // Denotes 11th month (November)This implies that the standard time takes effect on 1st Sunday of November, which is effectively November 1, 2015. |
TimeZoneStandardSecond |
Second when standard time takes effect for the user as per the local time zone. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
TimeZoneStandardYear |
Local time zone standard year for the user. Is set to 0 to indicate every year. System calculated based on the time zone specified for the user in the TimeZoneCode column. |
See also
SystemUser Entity
Time Zone Entities
Configure the behavior and format of the date and time column using code
User and Team Entities
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for