Convert Missing or Invalid Dates in Databases to Null

Category:
Database
Type:
Snippets
Difficulty:
Beginning
Author:
Intelligent Solutions Inc.

Version Compatibility:

More information:
Some data sources (e.g., FoxPro) insert "12:00:00 AM" as the value for a date field when no value has actually been supplied. This function returns Null when passed either an invalid date or a value of 12:00:00 AM.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: