I am trying to
IMPORTRANGE if the condition in
column1 that is text formated ( Column1 = September 4, 2019 alas 5:10 pm ) contains the word September.
I am using the following formula. The other columns work fine because they contain just a single word. Since column 1 is not a single word it doesn't work. How can I use a condition that contains September?
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1YcJh57OVzaeUfHhR-xHmvYums1KIwrbGYoRouXAE7k8/edit#gid=661495879", "Leads!A2:L30000"),"SELECT Col2 WHERE ((Col9 = 'Peugeot') OR (Col10 = 'Peugeot')) AND (Col14 = 'Septiembre')")