Help with INSERT and dates ...

[wanttoscript]

I am a REAL beginner ... so please don't laugh.

I am having trouble inserting a date into a table:

INSERT INTO call_records (date) VALUES (#10/25/02#)

"call_records" is a table, with the field "date" which os formatted for general date input.

what is the correct syntax?
(or where can I find documentation so I can learn?)

Thanks for your help.

 

[mikey69]

Have just put up a post in another thread which answers this query