Convert Missing or Invalid Dates in Databases to Null
Category:
DatabaseType:
SnippetsDifficulty:
BeginningAuthor:
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: