Problem with inserting "DATE" in reports

[Larry Fox]

The "Date and Time" option on the Insert Menu is broken. It generates a "#Name?" error.



Can someone please help me resolve this problem.

Thanks - Larry

[rpeare]

I have no idea what you're talking about but if you're trying to insert a date field using a SQL statement you have to put # signs around it for instance

INSERT INTO tblTest (StartDate, EndDate) VALUES (#1/1/2011#, #1/15/2011#)