i have designed a form to collate data and stored in a table in the sqlserver database. However, I am experiencing problems with the gathered data. Every piece of information transferred to the data base is exactly as input by the user except for the date. For example, when a user selects a date say february 26, 2007 and then clicks the add button what reflects in the date column in the database is 01/01/1900.
What may be the problem?