Identify possible Y2K noncompliant database columns

The thing to look for here is columns in your database that either display externally or store internally dates with only two digits for the year part. Obviously, the date format depends on the makeup and structure of your database.

Be aware that it is possible for a database to store dates internally as four digits for the year part but to display them (via Select statements) with two digits. If this is the case, you might need to include some type of format function within the Select statement, depending on the style of your database.

The net result (output) of this task should be a list of database columns accessed by your Visual Basic application that might store the date incorrectly.