Can someone please tell me how to insert dates in MS Access?
when i insert dates i get an error
i use this statement
strSQ = insert into Expense (date,particulars,amount) values (‘” & strDate & “‘,'” & strParticulars & “‘, ‘” & strAmount & “‘)
db.execute strSQL
if i take off date, i am able to insert a record in another table, what could be the problem with inserting dates, i have tried using the #, but that does not work either..
Please help
