var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selecting records between 2 dates
I have a VB6 application connecting out to an Access 2000 DB and I'm trying to select all records where the Date in the DateRC field is between StartDate and EndDate.
The code I'm using is:
Set RS1 = MYDB.OpenRecordset("SELECT * FROM TaskTbl where DateRC >=#" & StartDate & "# AND DateComplete <=#" &EndDate &"#")
But this is just returning all records with any value in DateRC. If I do the same sort of thing in an Access query it seems to work fine.
... StartDate & "# BETWEEN DateComplete ...