TO_CHAR and BETWEEN Operator in my SQL Code

[JrExceler]

Hello Everyone,

I'm using SQL to get data from Access to my Excel Sheet, but I want to use the invoice date to have another filter criteria,
Do you know how can it be done?

I'm trying to convert the Invoice Date with:
" TO_CHAR(`Invoice Date`, 'YYYYMMDD')," & _
and then use BETWEEN in my Query,
however, it's giving me error.

¿is there any other way to get it?

This is my original Code that is Working,
But I cannot make it work with BETWEEN operator.

Any idea?

SQL0 = " SELECT " & _
        " Mat," & _
        " `Vol`," & _
        " Mon," & _
        " `Invoice Date`," & _
        " `Group`," & _
        " Dest," & _
        " source," & _
        " Sales"


SQL7 = " FROM `C:\Sales\NSalesAc.accdb`.NSales" & _
  " WHERE `Group` = '" & MODL & "' " & _
  " AND Dest = '" & MKT & "' "

     SQL = SQL0 + SQL7

 

[mole999]

you might want to consider using group in a query as it usually has a specific meaning

Have you tried to hardcode the date first in the SQL, then see how best to substitute the values

 

[xenou]

Note: TO_CHAR is not an MSAccess function.

 

[Joe4]

Posted here too: https://www.mrexcel.com/forum/excel-questions/999118-to_char-between-operator-my-sql-code.html

Similar to Cross-Posting, please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.