I've had {{zap_meta_human_now}} in a Zap for a long time and suddenly it’s returning MM/DD/YY without the time?
Best answer
Why is my Zap returning only the date without the time?
- Beginner
Best answer by drtanvisachar
Hello
That usually means the value is being reformatted somewhere in the Zap, not that {{zap_meta_human_now}} itself changed.
Check your Zap run history and look at the raw output where {{zap_meta_human_now}} is first used. If the time is there, then a later step is likely:
• Using Formatter and dropping the time
• Mapping into a field that only accepts a date
• Being reformatted by the destination app
If needed, add a Formatter step using Date Time → Format to control the exact output, for example:
MM/DD/YY h:mm A
Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard
+14- Zapier Orchestrator & Solution Partner
Hi
If you suspect an issue, open a ticket with Zapier Support: https://zapier.com/app/get-help?convers
Try using these system variables: https://help.zapier.com/hc/en-us/articles/35720226565773-Create-reusable-variables-to-use-in-Zaps#h_01JVYKPHMTRP24XQ15FJB9RZBN
+5- Zapier Solution Partner
- Answer
Hello
That usually means the value is being reformatted somewhere in the Zap, not that {{zap_meta_human_now}} itself changed.
Check your Zap run history and look at the raw output where {{zap_meta_human_now}} is first used. If the time is there, then a later step is likely:
• Using Formatter and dropping the time
• Mapping into a field that only accepts a date
• Being reformatted by the destination app
If needed, add a Formatter step using Date Time → Format to control the exact output, for example:
MM/DD/YY h:mm A
Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard
- Beginner
Thanks
That usually means the value is being reformatted somewhere in the Zap, not that {{zap_meta_human_now}} itself changed.
Yeah I had assumed that Data Out was exactly that, Data Out to Google Sheets (in this case). But turns out it takes into account the response from Google Sheets and what was actually inserted.
A rogue cell in Sheets had changed the formatting of the previous line, throwing the zap out!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.