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