Saving the current Date problem

[smeghead67]

Hello,



I have a form that I'm using to enter the date into a two tables. On the form the field is [createdate] in the properties it has an input mask of 99/99/0000;0;_ and a default value of =date()

The the fields on the tables that i insert this info into are Date/time and have an input mask of 99/99/0000;0;_ and no default value.

when i run the insert query, I get no errors. When i view the tables, the info in those fields is 12:05:44 AM

What?!? If i do a Dlookup in immediate mode, that is what i get too

Please help me.
Ted

[smeghead67]

Ok, I solved this myself...

When i ran my insert query

DoCmd.RunSQL "INSERT INTO [takeapart] ([createdate]) VALUES (" & [Forms]![takeapart]![createdate] & " );"

Should have been,

DoCmd.RunSQL "INSERT INTO [takeapart] ([createdate]) VALUES (#" & [Forms]![takeapart]![createdate] & "# );"

When you are dealing with Dates, always put the # symbol before and after the date to be inserted.

Ted

[RuralGuy]

Thanks for sharing your solution.