Editar

Compartilhar via

Specify time zone settings for a user

  • Artigo

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