How can I record date in Google Sheets via Zapier?

  • 13 June 2024
  • 4 replies

I am looking to record an event date in google sheets.  I tried the =today() formula in google sheets, but the date changes as time passes.   What can I input in Zapier, to record the correct date in a google sheet row, and it not change as days pass.

4 replies

Userlevel 7
Badge +14

Hi @LeasingXpert 


Formatter > Date & Time > Format

Thank you, but I am looking to do this without the time stamp.  I only want the date. 

Userlevel 7
Badge +14


Use this Zap action: Formatter > Date & Time > Format

You can change the format of the timestamp to be only the date

Userlevel 7
Badge +6

Hi @LeasingXpert,

+1 to what Troy suggested. You can use Date & Time formatter format function to remove the timestamp. Here’s how to set it up:

(view larger)

(view larger)

Hopefully, this helps!