Google Sheets node - filtering a date

Questions
1

I am using a Google Sheet node to read records from a Sheet.

each record has a timestamp like this: 2023-01-26T11:51:19.193-03:00

When I read the spreasheet, i would like to filter today’s records. However, if I use {{$today}} as filter, it will search records with the timestamp 2023-01-26T00:00:00.000-03:00 and won’t find a match because of the time of day.

Is there a simple way to filter today’s records using the timestamp?

I suspect it is possible using JavaScript but I am still at the very beginning of my JS online course.

2

Hi @fxholl, how about using the “Starts With” operation of the IF node with an expression like {{ $today.toFormat('yyyy-MM-dd') }} for the filtering?

image
image1915×891 61.7 KB

Example workflow:

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.