If I understood...
you have to transform the date variable as follows:
d="#" & d & "#"
, and that value you can use in INSERT statement as:
INSERT INTO tbl (id,date) VALUES(" & id & "," & d & ")"
HTH.
Reg,
NotNowJohn
...but the Soon is eclipsed by the Moon
|