Are you sure? How are you retrieving TRDATE from the resultset? Via GetString/GetString2? Another method? If via another method, how are you converting the retrieved value to a date? Also, are you sure you are storing NULLs? Could it be that when storing the date it is stored as '01/01/1970'? You have no code posted (retrieval and display), nor any screenshots of a data dump that we can go by, therefore my various questions.