INSERT Date

Question

I am trying to INSERT a date value in the form: Friday, February 06, 2004 into an Access field specified Date/Time Format: Long Date. What should the INSERT statment look like to do that? Also, what should the WHERE expression look like that returns all the records with the date field containing a date after Friday, February 06, 2004?

jptavare · Answer

the trick is you need to add '#' around the string that you are tring to pass as the dateTime i.e. INSERT INTO tableName ( yourDate ) VALUES ( #theDate# ); I hope this helps jptavare