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

[Stephen Gordon]

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

 

[Fagun Shah]

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

Try converting your Date column to Simple Text using Format Menu.

 

[Stephen Gordon]

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

Elegant solution as always @Fagun Shah