Been playing with this one and havent had any luck..
How would you write an sql statement to delete any dates previous to today's date.
I've tried the following

ie
sql="delete from MyTable where TheDate<" & date
sql="delete from MyTable where TheDate<" & "#" & date & "#"
sql="delete from MyTable where TheDate<" & "'" & date & "'"