MS Excel - New Database Query - using dates in Excel as criteria

[daggers]

Hi,

Does anyone know how to link dates in an Excel spreadsheet to criteria in Query?

For any other criteria, i.e. names or constants, it is simple - in Query, in the criteria field of the chosen data category put in [name], then in Excel link the criteria by selecting 'Query Parameters' and 'Get the value from the following cell'.

Then whenever the Query is refreshed, the criteria is lifted from the Excel spreadsheet.

Unfortunately it refuses to do this for dates! Does anyone know how to make it work for dates too?

Thanks
Ross

 

[ETID]

if using vba...
add the # sign..IE

"where somefield =#"+date$+"#"