are you running the SQL form inside Access???

I just ran this :

DoCmd.RunSQL ("delete * from test where thedate < #" & Date & "#")


(test was my table)

and it worked fine..deleted everything before today