Load between dates

[jacek27031]

Hi, what is wrong with this code? 

LOAD
"Buyer ID",
"%Customer ID",
Product,
"%Product ID",
%Date Where [%Date]>Date('10/1/2021') and [%Date]<Date('12/31/2021'),
Quantity,
"Seller Market",
"Type Of Sale"
FROM [lib://bms3_emea_root_folder/qvd_facts/f_channel_stiso_actual.qvd]
(qvd)
Where Match("Seller Market", 'GERMANY');

[Or · Accepted solution]

There's a "Where" in the middle of your Load which shouldn't be there. If this is a condition, it should be at the bottom with the rest of the conditions.

[jacek27031]

Thank you @Or , and how to add two conditions?

[Or · Accepted solution]

Where Conditions1

And Condition2

And Condition3

etc.