[RESOLVED] Maybe incorrect syntax for select statement SQL

[WestSideRailways]

Hello Everyone,
I am having a problem with the following line of code...

StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & "'"

if I use...

StateSQL = "select * from Petrol_Table where FuelDate >= '2013-12-01' and FuelDate < '2013-12-31'"

is works.

can anybody suggest what I am doing wrong.

Thanks for reading.