Is it possible to lookup a Google Sheets row using a date?

Hi All,

I've set up a workflow to run once a day to get the current date (without time) in the DD/MM/YYYY format.

The next action is a 'Google Sheets: Lookup Spreadsheets Row' that uses the Current Date value from the previous step to search the date column in the connected spreadsheet.

The date format in Google Sheets is also DD/MM/YYYY, but the Response Result is always 'Data not found'

Is it possible to look up a Google Sheets row using a date?

Cheers

Stephen

Hi All,

I've set up a workflow to run once a day to get the current date (without time) in the DD/MM/YYYY format.

The next action is a 'Google Sheets: Lookup Spreadsheets Row' that uses the Current Date value from the previous step to search the date column in the connected spreadsheet.

The date format in Google Sheets is also DD/MM/YYYY, but the Response Result is always 'Data not found'

Is it possible to look up a Google Sheets row using a date

Cheers

Stephen

And there I was trying every date format under the sun! :-)

Elegant solution as always @Fagun Shah