hi,
I have a problem with the insert query........
can u please tell me the correct way of getting system date for the access database.....
i have a issue table that has following fields
issue_date
user_id
book_id
status
return_date
and the query is
issue = "insert into issue(issue_date,user_id,book_id,status,return_date) values( 'sysdate', '"&session("user_id")&"','"&request.querystring("bid")&"','"&session("status")&"','sysdate+15')"
and the error is that instead of the real system date sysdate in issue_date field and susdate+15 in return_date field is inserted in the table......
plz help me and tell me the right way of writing the query.......Thank you very much
