recordset between 2 dates

[DMT Dave]

Hi Guy's, this one should be so easy but can't see the woods for the trees

I can't get the characters correct in this recordset ?

 Dim mStartDate as Date, mEndDate as Date
Set rs = CurrentDb.OpenRecordset("Select tblInvoices.InvoiceDate, tblInvoices.Name, tblInvoices.InvoiceNumber, tblInvoices.CostOfJob, tblInvoices.Paid, tblInvoices.PaidDate From tblInvoices WHERE InvoiceDate Between #" & mStartDate & "#" And " & menddate & #" & " ORDER BY InvoiceDate;")

[CJ_London]

"Select........Between #" & mStartDate & "# And #" & menddate & "# ORDER BY InvoiceDate;"

[DMT Dave]

Thank you for that