Using Google Query Language with Survey123 & Integromat.

[NDFAdmin]

Hello,

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.

Thanks!

Aaron

[JamesTedrick]

Hi Aaron,

As this is a question with Google's software, another forum might be more appropriate to look for the answer to this.