I am enjoying the ability to automate processes using Survey123 and Integromat, but have stumbled across an issue related to the query language used for Google Sheets. I have a scenario setup to send form responses to a Google Sheet and then search (filter) through the records to find certain information. However, I would like to search records by the current (today's) date, but am having issues getting the syntax correct using Google's query language. Here's some of what I've tried:
Select * where A = Today()
Select * where A = date 'Today()'
Select * where A = date '"&TEXT(today(),"yyyy-mm-dd")&"'")
The date format I am using is yyyy-mm-dd.