Loading

INSERT Date

flbreen

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

jptavare22y ago
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