Simple VBA Date issue (SQL)

[vapid2323]

I just want to get a Date back when I run the following

DoCmd.RunSQL "INSERT INTO [tblSurveillance] ([fk_SiteID], [Surv_Audit]) VALUES (" & Forms!frmMain_toplg!SubForm1!SiteID.Value & "," & #1/1/2000# & ");"

But instead I get 12:00:43 AM

I am sure this is simple, Help!

 

[pbaldy]

Try

...VALUES (" & Forms!frmMain_toplg!SubForm1!SiteID.Value & ", #1/1/2000#);"

I'd concatenate if getting the date from a form or something.

 

[vapid2323]

I still need practice it would seem

Thanks!

 

[pbaldy]

No problemo!