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 want to create a 'date stamp' for 'today' and have it as today in AEDT (Australia/Sydney) timezone.

I've easily created the date stamp but it comes up in another (don't know which one) timezone. Easy to identify because today in Sydney is the 15th and it is outputting the 14th. I need the date stamp for a legal letter that will be generated so it is important that it is accurate. It's not simply a matter of adding a day "+1 day" because eventually when the clocks tick over from midnight from the timezone in which the server is the date output will be in the future. Also obviously not good 🙂 I've tried adding hours to compensate but nothing seems to work.

Screenshots of the step included.

Any advice much appreciated.

Thanks in advance.

Kind regards

Paul

Screen Shot 2019-10-15 at 10.17.12 am.pngScreen Shot 2019-10-15 at 10.17.40 am.pngScreen Shot 2019-10-15 at 10.17.53 am.pngScreen Shot 2019-10-15 at 10.18.14 am.png


Time... time zones... and time formatting. If only we'd all accept a universal timezone and ditch daylight savings and other mumbo jumbo. And yes there is real science behind ditching timezones... but I digress.


@pauljlange are you familiar with the Zapier built in function called {{zap_meta_human_now}}? This page explains more about it.

Once you use Zap Meta Human Now, then you just have to adjust the timezone settings for the Zapier account or check the actual settings for the zap. You could follow the steps here to get a formatter and switch "from" one timezone to another, but I would hate seeing you add time instead of just converting the timezone. (see the "from" and "to" timezone settings in the screenshot below)

5579E725-B590-4EE7-B525-A4276B43391B.pngHopefully this helps. Let us know if it worked or if you need additional assistance.


OMG thanks Paul. I vaguely remember hearing about it and THANK YOU for putting that front and centre for me. Perfect

Warmest regards

P


Happy to help Paul. I use the Zap Meta Human Now variable in a lot of zaps, it's quite handy!


One small precaution; if you use {{zap_meta_human_now}} to insert the current date/time and haven’t gotten around to setting the timezone in your Zap settings then your Zap may stop running with no issue or error message.

Hey 😃 I still don’t get sydney time
When i add {{zap_meta_human_now}}  tag it keeps it in the mm/dd/yyyy format

The setting in google sheets are also DDmmyyyy so not sure how else to do this?

 

Hi @Joshbuss!

If you need your date to be in a different format/timezone, you can look into our Formatter: https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps

See if that helps at all :)

Reply


Terms & Conditions