This is basically all I had, when I put in the date into my db.
SQL = "INSERT INTO table (tabledate) VALUES (" & Now() & ")"
I don't see a problem with it, nor would you. But at odd time, it did the little screw up I had told you.
I don't know why it happend. all it was, was a mistake for the day and month. And I fixed it by:
Month(Now()) & "/" & Day(Now()) & "/" & Year(Now()) & " " & FormatDateTime(Now(), vbLongTime)
And Whammy's idea:
I have my db's all set up to do it all 3 ways. So, if anyone of them messes up, and they are do the problem anyways, I'll post another topic.
Whammy, if it's all right with you and everyone else, this topic can be locked. I think the problem is sovled...