Date Effective Patterns (White paper)
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This white paper describes how to use date effective tables, also known as valid time state tables, to store and track object history in Microsoft Dynamics AX 2012.
The difference between the two types of valid time state tables
How valid time state tables are integrated with the security framework
Various update modes
How to use the validtimestate keyword in queries
Scenarios that are not supported by the framework
The paper also suggests design patterns for forms that use valid time state tables.