Query Using Date - Please HELP!!

[Erik S. Nachbahr]

        
        
        
        Greetings All!
         
        I am crazy, what am I doing wrong here. I want to Run a query on
an access date/time field. I want to generate the dates to query with
myself
         
        This code Works........
         
        SELECT      
        Sum(ToyotaExtra_Daily) AS ToyotaExtraTotal,
        Sum(Extended_Daily) AS ExtendedTotal
        FROM    SFI 
        Where Date between {d '2001-01-26'} and {d '2001-01-25'}
         
        However, what I want to do is something like this:
         
        Create two dates based on user form data
         
         <cfset D1 = "{d '#userYear#-#userMonth#-#userDay#'}">
         <cfset D2 = "{d '#userYear#-#userMonth#-01'}">
         
        And then invoke them in my query:
         
        SELECT      
        Sum(ToyotaExtra_Daily) AS ToyotaExtraTotal,
        Sum(Extended_Daily) AS ExtendedTotal
        FROM    SFI 
        Where Date between #D1# and #D2# 
         
        I get an error when I try the second method! 
         
        Please cc [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
as I get the list in digest
        thanks!

��b��!���0���j�!����o�~֥�.��~�"�w(��'���r��zm����h�Ǩ}����ܢo�ױq���כj�b��