I have this query =QUERY('Monitor'!$A$4:$AB, select * WHERE  & IF(C2=Yes,A=1 ,IF(C2=No,A=0 ,(A=0 OR A=1) )) & AND  & IF(ISBLANK(C3),,D=&C3& ) & AND & IF(ISBLANK(C4),B IS NOT NULL ,B=&C4& ) & AND  & IF(ISBLANK(C5),F IS NOT NULL ,F> &C5& ))The last part refers to dates where C5 = Date in format YYYY/MM/DDF = Column with dates in same formatI want to get only the rows where the date is larger than that of cell C5.I don't get an error back, I just get an empty range. I've checked if the other filters could be the reason but they're not.Couldn't find answer here and do not want to use FILTER.Any ideas?
Query date in Google Sheets in format >date
google spreadsheets;google spreadsheets query
Worked like this=QUERY('Monitor'!$A$4:$AB, select * WHERE  & IF(C2=Yes,A=1 ,IF(C2=No,A=0 ,(A=0 OR A=1) )) & AND  & IF(ISBLANK(C3),,D=&C3& ) & AND & IF(ISBLANK(C4),B IS NOT NULL , B=&C4& ) & AND  & IF(ISBLANK(C5),F IS NOT NULL ,F> date'&TEXT(C5,yyyy-MM-dd)&' ))