@Taifun , Suppose if i adjust the query to search the name matching with date , then results turned empty. I dont know why. I used the same blocks but instead of namelabel.text i used datelabel.text field.
Is it not possible to search the field based on date? And i display the date in the label by using web component
web site address :
and the blocks are ,
Query link look like this,
https://docs.google.com/spreadsheets/u/1/d/10ZXG9P0s4mYQhJn4KbVJy3I5RNEYP7q3HWn85caBwYs/gviz/tq?tqx=out:csv&sheet=Sheet1&tq=SELECT%20B%2CC%2CD%20where%20A%20matches%2006-02-2021
I have used both type of text as shown in below picture
but for both the type of date i got the following error
UBDATES:
I followed this tutorial too for how to use date query in google sheet,
https://infoinspired.com/google-docs/spreadsheet/how-to-use-date-criteria-in-query-function-in-google-sheets/