Help With SQL - Date Range (1 Viewer)

[Shaunk23]

I have the below written as a criteria.. but its not working.. I have the format wrong i suppose.. It should work for a date range.

TmpDate1 = Format(Me.DateStart, "mm/dd/yy")
Tmpdate2 = Format(Me.DateEnd, "mm/dd/yy")


SQLDATE = "(((QuoteMain.[DateOfQuote]) BETWEEN & #" & TmpDate1 & "# & AND & #" & Tmpdate2 & "#))"

 

[Shaunk23]

SOLVED - SQLDATE = "(QuoteMain.[DateOfQuote] BETWEEN #" & Format(TmpDate1, "mm/dd/yy") & "# AND #" & Format(Tmpdate2, "mm/dd/yy") & "#)"