Outlook messages with blank date field export with date stamp 1/1/4501

Created by: Nate Oleson
Created date:
Last Updated date:


Ingest an Outlook email or archive that contains a "blank" date field.  After exporting from AccessData, the date shows as 1/1/4501.


According to Microsoft, the date field can never be stored as blank or NULL.  If no value is written to the field, the value will default to 1/1/4501.

For more information see:

Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators by Sue Mosher, "Working with dates and times" pg 207



There technically is no resolution to this issue as this is working as designed by Microsoft.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk