Hi,

I need to import an rage that matches the word "cricket" and also who has a date of birth from 1st October 2003 and later. Here is the formula I have written, but doesnt seem to work:


=QUERY(IMPORTRANGE("1A98O9wikSyUM40aCFJfMuaT3o9KKWCVHG7eFX6Dl918","2019_MASTER_ROLL!A2:AC"),"SELECT Col1, Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col20 WHERE Col20 MATCHES 'Cricket' and (Col16 >= date '"&TEXT(DATEVALUE("1/9/2003"),"dd-mm-yyyy")&"'",1)
If you need further information, please let me know. Thanks