Convert Missing or Invalid Dates in Databases to Null
Author:Intelligent Solutions Inc.
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.