handling invalid dates from db using dbeditbox
Posted on 2006-07-13
I have a Dbase IV DB with dates stored as MM/DD/YY many of the dates in that db are NOT valid for example 00/00/00. I have a form that connects to the DB with BDE and uses DBeditboxes to display/edit the data in the database.
The problem is when there is no date, the date is being stored as 00/00/00 in my db (I think this is the case it's what I see when I look at the record in dbase.exe although it doesn't come out like that when I do a query on it through BDE). My DBEditBox when this situation occurs (00/00/00) will display what appears to be a random date (as do my queries), also a strange side effect is when you click to enter the edit box the date somewhat randomly changes for no reason apparent to me.
Any advice on how to handle an unentered/invalid date, what I'm looking for is if the date is stored as 00/00/00 in the db display it as such or display nothing. When there is an invalid date such as 99/99/99 in my db, my dbEditBox actually displays 0/0/0000 for the date which is what I'm looking to do when there is no date entered yet.