Syntax to query an Access database date field using asp
If you have an Access database with a date/time field, and you want to query the results using only the date portion of that field from an asp field.
strSQL2 = "SELECT results.*, format([timestamp], 'mm/dd/yyyy') as RealDate FROM results where location_id = '" & location
& "'" & " and datevalue(timestamp) between #" & begindate & "# and #" & enddate & "#"