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.

Topics include:

  • 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

  • Runtime behaviors

  • Scenarios that are not supported by the framework

The paper also suggests design patterns for forms that use valid time state tables.

Download the paper.