Date error using INSERT INTO

[BTilson]

I'm running an sql statement that works perfectly, except for when I use date fields. For example, when I try to insert the value "8/15/2004" the actual resultant field in the table has the value "12/30/1899"

Why is this? I can't figure it out.

Thanks.

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[lespaul]

are you enclosing them in date delimiters (# signs)?

#8/15/2004#

leslie

 

[BTilson]

Lol. That was my problem. *hits self in head* Thanks hehe.

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[lespaul]

amazing how the simplest things can just blow you out of the water!!

glad to help

les