How to reference a date variable in SQL string

[BeeDeeBee]

Does anyone know how to reference a variable to be interpreted as a date in an SQL string. I keep getting a "type mismatch" error. I know the field, usdatabase.TransactionDate will accept only dates.
I have tried substituting the &'s in the sevenyearsago variable with #, and it doesn't work.
Here are the relevant 2 lines of code:

sevenyearsago=DateAdd("m",-84,now)

sqlSTR=&quot;DELETE usdatabase.*, usdatabase.TransactionDate FROM usdatabase WHERE usdatabase.TransactionDate < '&quot;&amp;sevenyearsago&amp;&quot;'&quot;
Any help will be more than appreciated.

 

[BeeDeeBee]

I finally figured it out. In case anyone else has this same question, the answer is to surround the variable with #, instead of ' e.g., as in my situation:
#&quot;&amp;sevenyearsago&amp;&quot;#&quot;