formatDate is not registering

How To
1

Hey you guys,

I am trying to use the Google Sheets ‘search rows’ module to locate all rows with Todays date.

  • I don’t know if I don’t have it formatted correctly or what but the automation is supposed to:
  1. Search the Google Sheet for the rows that have todays date
  2. Output those rows
  3. Use perplexity to create a actionable step to move forward with

  • In hind sight, I have a nurture sequence taking place that is supposed to send a C-Suite exec a weekly update about recent events that are going on within their industry.

  • However, I can’t seem to get Google Sheets to locate the dates with todays date.

  • Thanks for all your help!

  • Cameron

Loom Video:

format date 2
format date 2420×1370 52.7 KB

format date
format date1445×920 107 KB

2

We can close this ticket out you guys, I figured it out (with the help of ChatGPT, lol).

Make is the BEST!

1 Like
3

I had to change the format within my filter to ‘-’ instead of ‘/’

1 Like
4

Hello @Cameron_Williams :waving_hand:

Thank you for coming back and sharing the solution! It can help soo many Makers. :hugs: