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.
Question
How can I record date in Google Sheets via Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Timestamps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
Formatter > Date & Time > Format
+14- Zapier Orchestrator & Solution Partner
Use this Zap action: Formatter > Date & Time > Format
You can change the format of the timestamp to be only the date
+6- Zapier Staff
Hi
+1 to what Troy suggested. You can use Date & Time formatter format function to remove the timestamp. Here’s how to set it up:
Hopefully, this helps!
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.