Time Zone Rule (TimeZoneRule) table/entity reference (Microsoft Dataverse)

Definition for time conversion between local time and Coordinated Universal Time (UTC) for a particular time zone at a particular time period.

Messages

The following table lists the messages for the Time Zone Rule (TimeZoneRule) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Associate Event: True	Associate records	Associate records
Disassociate Event: True	Disassociate records	Disassociate records
Retrieve Event: False	GET /timezonerules(timezoneruleid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /timezonerules See Query data	Query data

Properties

The following table lists selected properties for the Time Zone Rule (TimeZoneRule) table.

Property	Value
DisplayName	Time Zone Rule
DisplayCollectionName	Time Zone Rules
SchemaName	TimeZoneRule
CollectionSchemaName	TimeZoneRules
EntitySetName	timezonerules
LogicalName	timezonerule
LogicalCollectionName	timezonerules
PrimaryIdAttribute	timezoneruleid
PrimaryNameAttribute	timezoneruleversionnumber
TableType	Standard
OwnershipType	None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• Bias
• DaylightBias
• DaylightDay
• DaylightDayOfWeek
• DaylightHour
• DaylightMinute
• DaylightMonth
• DaylightSecond
• DaylightYear
• EffectiveDateTime
• StandardBias
• StandardDay
• StandardDayOfWeek
• StandardHour
• StandardMinute
• StandardMonth
• StandardSecond
• StandardYear
• TimeZoneDefinitionId
• TimeZoneRuleId
• TimeZoneRuleVersionNumber

Bias

Property	Value
Description	Base time bias of the time zone rule.
DisplayName	Bias
IsValidForForm	True
IsValidForRead	True
LogicalName	bias
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

DaylightBias

Property	Value
Description	Time bias in addition to the base bias for daylight savings time.
DisplayName	Daylight Bias
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightbias
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

DaylightDay

Property	Value
Description	Day of the month when daylight savings time starts.
DisplayName	Daylight Day
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightday
RequiredLevel	SystemRequired
Type	Integer
MaxValue	31
MinValue	0

DaylightDayOfWeek

Property	Value
Description	Day of the week when daylight savings time starts.
DisplayName	Daylight Day Of Week
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightdayofweek
RequiredLevel	SystemRequired
Type	Integer
MaxValue	6
MinValue	0

DaylightHour

Property	Value
Description	Hour of the day when daylight savings time starts
DisplayName	Daylight Hour
IsValidForForm	True
IsValidForRead	True
LogicalName	daylighthour
RequiredLevel	SystemRequired
Type	Integer
MaxValue	23
MinValue	0

DaylightMinute

Property	Value
Description	Minute of the hour when daylight savings time starts.
DisplayName	Daylight Minute
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightminute
RequiredLevel	SystemRequired
Type	Integer
MaxValue	59
MinValue	0

DaylightMonth

Property	Value
Description	Month when daylight savings time starts.
DisplayName	Daylight Month
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightmonth
RequiredLevel	SystemRequired
Type	Integer
MaxValue	12
MinValue	0

DaylightSecond

Property	Value
Description	Second of the minute when daylight savings time starts
DisplayName	Daylight Second
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightsecond
RequiredLevel	SystemRequired
Type	Integer
MaxValue	59
MinValue	0

DaylightYear

Property	Value
Description	Year when daylight savings times starts.
DisplayName	Daylight Year
IsValidForForm	True
IsValidForRead	True
LogicalName	daylightyear
RequiredLevel	SystemRequired
Type	Integer
MaxValue	32768
MinValue	0

EffectiveDateTime

Property	Value
Description	Time that this rule takes effect, in local time.
DisplayName	Effective Date Time
IsValidForForm	True
IsValidForRead	True
LogicalName	effectivedatetime
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

StandardBias

Property	Value
Description	Time bias in addition to the base bias for standard time.
DisplayName	Standard Bias
IsValidForForm	True
IsValidForRead	True
LogicalName	standardbias
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

StandardDay

Property	Value
Description	Day of the month when standard time starts.
DisplayName	Standard Day
IsValidForForm	True
IsValidForRead	True
LogicalName	standardday
RequiredLevel	SystemRequired
Type	Integer
MaxValue	31
MinValue	0

StandardDayOfWeek

Property	Value
Description	Day of the week when standard time starts.
DisplayName	Standard Day Of Week
IsValidForForm	True
IsValidForRead	True
LogicalName	standarddayofweek
RequiredLevel	SystemRequired
Type	Integer
MaxValue	6
MinValue	0

StandardHour

Property	Value
Description	Hour of the day when standard time starts.
DisplayName	Standard Hour
IsValidForForm	True
IsValidForRead	True
LogicalName	standardhour
RequiredLevel	SystemRequired
Type	Integer
MaxValue	23
MinValue	0

StandardMinute

Property	Value
Description	Minute of the hour when standard time starts.
DisplayName	Standard Minute
IsValidForForm	True
IsValidForRead	True
LogicalName	standardminute
RequiredLevel	SystemRequired
Type	Integer
MaxValue	59
MinValue	0

StandardMonth

Property	Value
Description	Month when standard time starts.
DisplayName	Standard Month
IsValidForForm	True
IsValidForRead	True
LogicalName	standardmonth
RequiredLevel	SystemRequired
Type	Integer
MaxValue	12
MinValue	0

StandardSecond

Property	Value
Description	Second of the Minute when standard time starts.
DisplayName	Standard Second
IsValidForForm	True
IsValidForRead	True
LogicalName	standardsecond
RequiredLevel	SystemRequired
Type	Integer
MaxValue	59
MinValue	0

StandardYear

Property	Value
Description	Year when standard time starts.
DisplayName	Standard Year
IsValidForForm	True
IsValidForRead	True
LogicalName	standardyear
RequiredLevel	SystemRequired
Type	Integer
MaxValue	32768
MinValue	0

TimeZoneDefinitionId

Property	Value
Description	Unique identifier of the time zone definition.
DisplayName	Time Zone Definition
IsValidForForm	False
IsValidForRead	True
LogicalName	timezonedefinitionid
RequiredLevel	SystemRequired
Type	Lookup
Targets	timezonedefinition

TimeZoneRuleId

Property	Value
Description	Unique identifier of the time zone rule.
DisplayName	Time Zone Rule
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only
DisplayName	Time Zone Rule Version Number
IsValidForForm	True
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	SystemRequired
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OrganizationId
• VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the time zone rule.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the time zone rule was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the timezonerule.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the time zone rule.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the time zone rule was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the timezonerule.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier of the organization associated with the time zone rule.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	None
Type	Lookup
Targets	organization

VersionNumber

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

• lk_timezonerule_createdby
• lk_timezonerule_createdonbehalfby
• lk_timezonerule_modifiedby
• lk_timezonerule_modifiedonbehalfby
• lk_timezonerule_timezonedefinitionid

lk_timezonerule_createdby

One-To-Many Relationship: systemuser lk_timezonerule_createdby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdby
ReferencingEntityNavigationPropertyName	createdby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_timezonerule_createdonbehalfby

One-To-Many Relationship: systemuser lk_timezonerule_createdonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdonbehalfby
ReferencingEntityNavigationPropertyName	createdonbehalfby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_timezonerule_modifiedby

One-To-Many Relationship: systemuser lk_timezonerule_modifiedby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedby
ReferencingEntityNavigationPropertyName	modifiedby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_timezonerule_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_timezonerule_modifiedonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedonbehalfby
ReferencingEntityNavigationPropertyName	modifiedonbehalfby
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_timezonerule_timezonedefinitionid

One-To-Many Relationship: timezonedefinition lk_timezonerule_timezonedefinitionid

Property	Value
ReferencedEntity	timezonedefinition
ReferencedAttribute	timezonedefinitionid
ReferencingAttribute	timezonedefinitionid
ReferencingEntityNavigationPropertyName	timezonedefinitionid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
timezonerule