I have an input screen that takes a user id, password, and date range. I want to compare that date range to the date field of each record for that user id. I can't find the conversion needed in order to be able to accomplish this. The select line is
rs.Open "SELECT * FROM games where uid= '"& Username &"' and date >=" & begdt & " and date <=" & enddt, conn, 1
I am accepting the date in text format. Is there a different format I should be using?