Filters data with SQL imports in excel

[Dark0Prince]

I don't know how to use SQL to write "in less than" "Today-10 days" using the wizard. I just started using SQL and hope this is the write place to ask. The column I'm filtering is a date so the in less than comes write up, but i don't know how to do the second part.

 

[Fazza]

maybe

YourDateField < (Date - 10)

this is done by editing the SQL. so either in the wizard (at the last step of the wizard choose the option to edit), or from the worksheet via the data connection properties/definition, or via VBA

 

[Dark0Prince]

I get an error that says Didn't expect '<' after the select column list

SELECT Dbtr_General_Inf.ACCOUNT_NUM1, Dbtr_General_Inf.Last_Name, Dbtr_General_Inf.First_Name, Dbtr_General_Inf.Address_Line_1, Dbtr_General_Inf.Address_Line_2, Dbtr_General_Inf.City, Dbtr_General_Inf.State, Dbtr_General_Inf.Zip_Code, Dbtr_Clnt_Generl_Inf.AcctNUM_From_Client, 
Dbtr_Status.Disposition, Dbtr_Status.Paid_In_Full_Date
Paid_In_Full_Date < (Date - 10)
FROM SQLUser.Dbtr_Clnt_Generl_Inf Dbtr_Clnt_Generl_Inf, SQLUser.Dbtr_General_Inf Dbtr_General_Inf, SQLUser.Dbtr_Status Dbtr_Status
WHERE Dbtr_Clnt_Generl_Inf.ACCOUNT_NUM = Dbtr_General_Inf.ACCOUNT_NUM AND Dbtr_Clnt_Generl_Inf.ACCOUNT_NUM = Dbtr_Status.ACCOUNT_NUM AND Dbtr_General_Inf.ACCOUNT_NUM = Dbtr_Status.ACCOUNT_NUM AND 
((Dbtr_General_Inf.ACCOUNT_NUM1=622201))
ORDER BY Dbtr_Status.Paid_In_Full_Date

 

[Dark0Prince]

Solved