SQL code for returning this weeks salesdata

[AlexMwells]

Hi,

Can anybody spot the error in my code please

SELECT HistoryLines.DDate, CustomerMaster.CustomerDesc, HistoryLines.Description, HistoryLines.Qty, HistoryLines.UnitPrice, HistoryLines.DiscountAmount
FROM HistoryLines INNER JOIN CustomerMaster ON HistoryLines.CustomerCode = CustomerMaster.CustomerCode
WHERE datepart("ww"[HistoryLines.DDate],2)=datepart("ww",[Date()],2);
 

the error message is complaining of a missing operator within the WHERE clause. I am attempting to show sales data for this week only. I think the "2" will mean the week will start on a monday. The tables are linked to Pastel Accounting package - I am not sure if that makes a difference.

Thanks

Alex

[AlexMwells]

Hi,

I actually spotted them as soon as I posted. The correct code is given below.

SELECT HistoryLines.DDate, CustomerMaster.CustomerDesc, HistoryLines.Description, HistoryLines.Qty, HistoryLines.UnitPrice, HistoryLines.DiscountAmount
FROM HistoryLines INNER JOIN CustomerMaster ON HistoryLines.CustomerCode = CustomerMaster.CustomerCode
WHERE datepart("ww",[HistoryLines.DDate],2)=datepart("ww",Date(),2) AND Year( [HistoryLines.DDate]) = Year(Date())
ORDER BY HistoryLines.DDate DESC;
 

thank

Alex