ASP‎ > ‎

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 & "#"

Comments