Editing Data Entered Dates
For many, many years I have been using the 'Short Date' format for entry of dates on my Access Forms. Trusting that my dates were solid.
We are now moving the Access MDB to SQL Server. I got an error on one of my tables that had a date field. SQL didn't like some of the dates in the date field of the table and cancelled the import.
I researched and found these dates: 2/15/104, 9/15/104, 3/1/112, 4/4/204 etc.. Of 111,000 records only 25 had dates with a year less than 1000. To test, I removed the records with those dates from the file and the import worked perfectly, building a SQL table.
I realize that these are valid dates but certainly not correct for the intended purposes of the application. Obviously using the 'Short Date' format is not preventing entry of some really bad years.
What are you all using to make sure only valid dates get into the DB?
We are now moving the Access MDB to SQL Server. I got an error on one of my tables that had a date field. SQL didn't like some of the dates in the date field of the table and cancelled the import.
I researched and found these dates: 2/15/104, 9/15/104, 3/1/112, 4/4/204 etc.. Of 111,000 records only 25 had dates with a year less than 1000. To test, I removed the records with those dates from the file and the import worked perfectly, building a SQL table.
I realize that these are valid dates but certainly not correct for the intended purposes of the application. Obviously using the 'Short Date' format is not preventing entry of some really bad years.
What are you all using to make sure only valid dates get into the DB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER