Another syntax error in SQL

[aikidokid]

I am getting the above error with the following:

strSQL = "SELECT * FROM tbl_Finances"
strSQL = strSQL & " WHERE Finance_Date > #" & dtDateOne & "#"
strSQL = strSQL & " AND < #" & dtDateTwo & "#"
strSQL = strSQL & " ORDER BY Finance_Date"

I cannot see anything wrong with the output below!

debug.Print strsql
SELECT * FROM tbl_Finances WHERE Finance_Date > #01/06/2007# AND < #30/06/2007# ORDER BY Finance_Date
SELECT * FROM tbl_Finances WHERE Finance_Date > #01/06/2007# AND < #30/06/2007#
SELECT * FROM tbl_Finances WHERE Finance_Date > #01/06/2007#
SELECT * FROM tbl_Finances