Follow

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

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

Symptom:

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

Cause:   

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

and

https://answers.microsoft.com/en-us/msoffice/forum/all/in-user-defined-fielddatetimedisplays-weird/d4ca95cb-ec8c-478e-a810-25cfeaa1b671

Resolution:

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

Comments

Powered by Zendesk