Filter on datetime condition not working

Hi Michelangelo,
just to keep everything in order in here as well, as I explained in the ticket, Google Sheets usually returns a date as a string, meaning that when you want to compare the date against for example the “now” variable, you need to use parseDate function to parse the string and create a date.

Additionally, when parsing the date, the correct datetime structure needs to be specified in the function, when Google Sheets returns DD/MM/YYYY, you need to use this format in the function as well.

Have a nice day :slightly_smiling_face:
David P.

1 Like