>How do write a code that goes through all my database table looking for invalid dates residing in the tables? I need it to list the table name, field name and the invalid date.
>
>thanks community
>
>Nick
Define the rules for an invalid date. If they are in a date field, they are valid iro day/month/year. If they are stored in character fields then you could convert to date inside a TRY ... ENDTRY and see if an error occurs.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.