Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am having an issue with the Formatter's Date / Time feature in one of my Zaps. The Zap is designed to create a new row in a Google Sheets spreadsheet every time a certain trigger event happens. I added a step with the Formatter by Zapier to generate a timestamp of the current date and time for each new row.

In the Formatter setup, I have used 'Now' as the input and 'YYYY-MM-DD HH🇲🇲ss' as the 'To Format'.

However, I've noticed that even though the date is correct, the time always remains the same and does not reflect the current time when the Zap runs.

Any ideas?

Hmm @growth.land this is interesting, can you please provide a screenshot of your Formatter set up? From my knowledge, this isn’t the intended outcome and I’d like to take a closer look at what’s going on. 

Hola @chanelle 

Thx for answering.

Here they go:

 

 

 

 

Hi there @growth.land,

I’m jumping in to see if I can help!

I replicated the Formatter setup that you’re using. After looking into it, it appears that the issue lies with the typed data in the “Input” field. It seems that the typed “Now” value isn't being recognized by the Formatter. To resolve this, I recommend using the {{zap_meta_human_now}} data instead. This should provide the desired result.

Here’s what it’ll look like:

1c516b061e35f8c591ce6f0b0a939bf4.png
(view larger)

2f54abaab742a0fd3ca008bc56633271.png
(view larger)

Hopefully, this helps! 😊

Hi @growth.land 

Try testing with the Zap ON, then check your Zap Runs to see the DATA IN/OUT for each Zap step, as sometimes the Zap Editor test data can be inaccurate.

OR

Help article about inserting system timestamp formats: https://help.zapier.com/hc/en-us/articles/8496275717261

Hi there @growth.land,

I’m jumping in to see if I can help!

I replicated the Formatter setup that you’re using. After looking into it, it appears that the issue lies with the typed data in the “Input” field. It seems that the typed “Now” value isn't being recognized by the Formatter. To resolve this, I recommend using the {{zap_meta_human_now}} data instead. This should provide the desired result.

Here’s what it’ll look like:

1c516b061e35f8c591ce6f0b0a939bf4.png
(view larger)

2f54abaab742a0fd3ca008bc56633271.png
(view larger)

Hopefully, this helps! 😊

Gracias @ken.a. It worked perfectly!

Hi @growth.land 

Try testing with the Zap ON, then check your Zap Runs to see the DATA IN/OUT for each Zap step, as sometimes the Zap Editor test data can be inaccurate.

OR

Help article about inserting system timestamp formats: https://help.zapier.com/hc/en-us/articles/8496275717261

Thx @Troy Tessalone.

@ken.a solution worked perfect. 

Hi @growth.land,

You are most welcome! I’m glad it worked!

If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help! 😊

Reply


Terms & Conditions