Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invalid Dates

Status
Not open for further replies.

Mighty

Programmer
Feb 22, 2001
1,682
US
Is there any way for me to run a query to find invalid dates in a table so that I can correct them?

Mighty
 
No. If the date is invalid, ODBC won't be able to work with it. THere are a couple of utilities for fixing bad dates on the Pervasive Component ZOne ( You could also write (or have written) an application that uses the Btrieve API to target your data files specifically and fix the bad dates.

Fixing the dates is only part of the solution. You need to make sure that no more invalid dates get into the data file.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top