Some records on the new VMs contain dates before 1900 and after 2154.

It is not possible to edit or work with most of those records because the application will issue an error when attempting to do so.

Jobs

To correct this situation you can manually edit the value of the related date fields directly on the SQL Server data base backend. This can be time consuming and it can be difficult to identify all corrupted records.

The enclosed utility will automatically normalize those records for you.

Please note, this process is designed for demo purposes and not meant to be used in production or implementation environments.


OofR


To run this process, after importing the XPO file, just right-click and select Open on the class AdjustOutOfRangeDates.


Installation

SourceCode2 Download the XPO file (MSDN Code Gallery)

Instructions – Out of range dates utility

Valid to be installed on the Microsoft Dynamics AX 2009 Demonstration VM: Refresh 3, 3.5 and 4


This posting is provided "AS IS" with no warranties, and confers no rights.