+44 203 287 0899 info@solvaa.co.uk
Red toy robot writing on a blackboard with chalk, with text A Simple Guide To Zapier on the blackboard.

Once you start to unleash the power of Zapier you will more than likely need to schedule a step to run at some point in the future.  For example, you might want to set up a cadence of sales emails to follow up leads.   You may want to automatically create project tasks to be actioned on a certain day.  Or you might want to send a reminder at a set time before a calendar event is due.

All of these things require you to express the date or time that you want something to happen, and this useful guide will give you a head start to show you how to express dates in Zapier so that you can become an automation superhero too!

 

Using specific dates in Zapier

If you want to specify a step in a zap to happen on a specific date (and/or at a specific time) then you can express that date in a number of ways.  Note that some apps use the 24-hour clock and others allow an am/pm qualifier.  You can also include the time zone if it’s different to yours.

Here are three ways of defining a specific date in Zapier:

  • MM/DD/YYYY HH:MMam/pm [TIMEZONE], e.g. 4/29/2021 10am GMT
  • Standard ISO format, e.g. 2021-04-29T14:45
  • UNIX timestamp, which is the number of seconds since 1/1/1970, e.g. 1619521823

You can find out more about ISO date formats here, and UNIX timestamps here.

 

Using relative dates in Zapier

Now although it’s useful to be able to set a specific date in a zap, what’s more powerful are the relative dates you can express.

For example, you may want to process any invoices on a Monday, so if you have an automation related to this then you can schedule it to happen ‘next Monday’.

Or you may want to automatically create a project task but for it always to be due the next day, so you can set the date to be ‘tomorrow’.

You can also use ‘next week Thursday’.

If you want to schedule something to happen in two hours then you can say ‘+2h’.

Or you can set a date to be yesterday by setting it to ‘-1d’.

Zapier has an article on how to adjust dates and times which you can read here.

 

Relative date and time codes

Using the ‘+2h’ and ‘-1d’ codes is so useful, but you need to know all the codes you can use.  Although most are obvious, it’s important to know the codes for ‘minutes’ and ‘months’ otherwise the time conversions may not happen as you expect them to!

  • s = seconds
  • m = minutes
  • h = hours
  • d = days
  • month = months
  • y = years

You can also use multiple codes, for example, if you wanted something to happen in two weeks and one day then you would use ‘+2w +1d’.

 

Time zones

If you don’t specify a time zone then Zapier uses the time zone from your account.  If you check the ‘My Profile’ page then you should have a time zone specified.  If it’s empty then choose the right one from the dropdown list.

 

Zap meta human

If you want to add the current day and time to a Zap, you can use the handy ‘zap meta human’ trick. Though this may sound complicated, it’s as simple as typing a phrase into the field of your Zap. Then, when the Zap runs, it will insert the time/date of the Zap run into the field. Here are three examples:

  • {{zap_meta_human_now}} – returns a human-readable date/time based on the default time zone in your profile.
  • {{zap_meta_timestamp}} – gives you a the time in UNIX (a format that some apps prefer)
  • {{zap_meta_utc_iso}} – provides the time/date in UTC (i.e. without a timezone) and formatted as a date/time stamp e.g. “2024-07-04T10:04:03+00:00”
     

You can find out more about how to insert the time your zap runs here including other timestamps which are available.

 

Changing the date format in Zapier

Now that you’ve learned how to express dates in Zapier, you may want to make them look nicer when they’re displayed to a human being, as ISO and UNIX dates aren’t very visually pleasing or user-friendly!  Even more normal dates might not be displayed how you’d like, for example, ‘2021-04-29T14:45’ might look nicer as ‘29th April 2021’.

Zapier has an inbuilt Formatter app that can convert dates and times from many different formats to others.  You can find out more here or download our cheat sheet which lists all the inbuilt Zapier functions which are brilliant automation shortcuts.

 

More useful Zapier articles

Once you get started with Zapier there’s so much you can do with it and we have plenty of articles which could spark ideas!

Check out our automation training programme

And finally, if you’re really keen to transform your business using automation, then visit the Solvaa Automation Academy. Our signature training programme, ‘Simple Automation Blueprint: Zero to Hero’ is aimed at anyone who wants to learn the fundamentals of business process automation from the experts – a sure-fire way to recession-proof your business.

It’s an 8-week blended learning course with on-demand videos, templates, resources and weekly group coaching sessions. And it’s more than just a Zapier course (although we do show you how to use Zapier like a pro) as you’ll learn about Process Mapping, Business Process Improvement and Business Process Management too – principles that can be applied to other areas of business too! 

Whether you are a complete novice or have been using Zapier for a while, our programme is for you. It’s perfect for individuals and teams in micro, small and medium-sized businesses, including solopreneurs, consultants and freelancers. You’ll have access to our experts and can participate in live calls where you can ask all your burning questions, as well as hands-on workshops to keep you on track with implementing your new skills. We run regular cohorts so there will be an opportunity for everyone to participate.

Our head trainer, Kelly Goss, is a specialist in business systems, process improvement and automation, and one of less than 100 Zapier Certified Experts in the world. Kelly has many years’ experience in optimising systems and processes, and implementing automations for clients and is now passing on her knowledge to students through our trademarked ‘4-Step Solvaa Automation Methodology®‘. 

Find out more via our dedicated Solvaa Automation Academy website.

Read more about how our certified experts use Zapier workflow automations to simplify processes and increase efficiency.

Solvaa is a process and automation consultancy specialising in improving sales, operations and financial administration workflows. We help you to simplify and streamline existing processes, integrate your business tools to make data transfer more efficient and automate manual tasks to increase productivity. We are Zapier Certified Experts, Pipedrive Certified Experts and Xero Certified Advisors. 

Contact us today to discuss how Solvaa can help you simplify, improve and automate all aspects of your business with Zapier to save you time, reduce costs and keep you agile as you grow.

Related Posts

Close-up of a woman using a portable credit card reader, holding a receipt which is being printed.

How to automate your sales funnel and win more business

Your sales cycle is one of the most important functions in your business so it's vital that it is efficient so that you can convert more sales and win more business. We have already covered how to automate your marketing tasks so this article concentrates on pushing...
Rear view of successful businessman relaxing in his office with his hands behind his head.

The benefits of automation in business

Everyone is talking about automation in business but many people aren’t sure what it actually means and what the benefits are.  It sounds really complicated and time-consuming, and (even worse) expensive!  Who would actually bother finding out?  We want to bust those...
Flatlay showing a computer keyboard, notepad and pen with text overlay “Calculate lead to customer conversion times”.

How To Calculate Lead To Customer Conversion Time

When you’re running a business it’s important to stay on top of your figures, and you should measure key performance indicators to review performance and plan for the future.  One of these metrics is the lead time from when a prospect is created to when they become a...
Flatlay of a macbook, glasses, coffee and plant on a dark desk with overlaid text saying 'Trello checklist for social media engagement'.

How to automate creation of a Trello checklist for handling Twitter engagements

Keeping on top of your social media accounts can be extremely time-consuming.  It takes so much longer than you think to create content and post it, and you can then waste hours on engagement. If you regularly nip in to check for comments then you can easily fall into...
Header image for the Solvaa blog post AI-tomation: how Zapier is AI to make automation easy. Part 3 - AI apps to turbocharge your Zaps

AI-tomation: how Zapier is using AI to make automation easy

Welcome to the third instalment of our series on leveraging artificial intelligence (AI) with Zapier. In this edition, we explore different ways Zapier supports AI, like OpenAI and ChatGPT. This blog post shows how 'generative AI' and automation can increase...

Automate It with Zapier book : Initial Reviews

Since our founder, Kelly's Automate It with Zapier book was released it has received some fantastic reviews on Amazon.  We knew the book would help new Zapier users but didn’t realise how useful it would be for people with different levels of Zapier knowledge. When...
Split image, the left side featuring a green plant in a green plant pot with white text on a blue shape saying “Use Zapier To Send a Simple Drip Email Sequence”. The right side features an image of Kelly Goss with the Solvaa, Xero, Pipedrive Expert and Zapier Certified Expert logos.

How To Use Zapier To Send A Simple Drip Email Sequence

Setting up a drip sequence of emails is super simple using Zapier and will save you a ton of time.  You can trigger them when something key happens in your business, such as winning a new client.  Having an automated drip of emails means that you’ll never worry about...
Yellow and orange post-it notes on a white wall, containing details of business tasks to be undertaken, representing a productivity concept. Overlaid text with ‘4 Productivity Tools That Will Change The Way You Do Business’ in black on a light blue background.

4 Productivity Tools That Will Change The Way You Do Business

As a business owner, life can get overwhelming. Between working on client assignments, running your own company, and maintaining some kind of family or social life, it’s almost impossible to do it all without a solid foundation and proper organisation. Productivity...
Solvaa blog image header AI-tomation: How Zapier is using AI to make automation easier. Part 1 - An overview of AI in Zapier.

AI-tomation: how Zapier is using AI to make automation easy

Artificial Intelligence (AI) has revolutionised the way we do business. With so much potential, apps are increasingly building AI into their product. Zapier, the popular automation app, is no exception. This is the first in a series of blog posts that will explore the...
Blue square with the text “How to automate a 7 day sales cadence of activities in Pipedrive” on a teal background with brass paperclips, a mug of black coffee, plant and a Solvaa logo.

How To Automate A 7 Day Sales Cadence Of Activities In Pipedrive

Creating a structured sales cadence is vital when prospecting for new business.  If you don’t follow up leads, or adopt a haphazard approach then they are less likely to convert into sales.  A sales cadence is a series of activities where you contact a person or...
Blog featured image for Solvaa blog post Using business automation software and excited to automate something new? Do these things first!

Using business automation software and excited to automate something new? Do these things first!

In the ever-evolving landscape of business processes, automation has become the cornerstone of efficiency and productivity. In this post, we'll delve into the art of enhancing your existing automation infrastructure by seamlessly integrating new automations into the...

How to automate your Pipedrive CRM sales processes

One of the biggest challenges for business owners is maintaining a streamlined sales process that is both reliable and easy to use. The modern sales process tends to rely on multiple tools and apps which, while making individual tasks easy to complete, leads to...
Decorative image - The featured image for the Solvaa blog post "AI-tomation: How Zapier is using AI to make automation easy Part 5 - Wrapping up and looking forward"

AI-tomation: How Zapier is using AI to make automation easy – Wrapping up and looking forward

In this series about AI automation, we've been exploring how Zapier is weaving AI throughout it's product to enhance user experience and power up automation.   If you missed our previous posts, you can find them here:  Part 1: An overview of AI in Zapier Part 2:...
Virtual assistant concept featuring a young woman with background of illustrated icons including 'like', 'share' and other digital marketing themes.

How To Use Zapier As A Virtual Assistant

So many people are choosing to be Virtual Assistants these days, as it is a flexible freelance role that is packed with variety.  There are many different types of VA, for example, Social Media VAs, Marketing VAs, Technical VAs, and eCommerce and Finance VAs. ...

8 Fun automations to do with Zapier

  While there’s no denying that Zapier can be a powerful tool to save you time and money in your business, there are actually some really fun, cool automations you can do with it which aren’t work-related! New apps are being added all the time to the already-huge...
Vintage blue toy robot isolated on a white background with black text “Will Zapier work for my business?” and Solvaa logo.

Will Zapier work for my business?

We get asked a lot whether Zapier will work for a particular business, because maybe some of the use cases we talk about don’t necessarily translate exactly to a particular sector.  Maybe you have a service-based business but have seen more product-based business case...
Illustration of a messy office with stacks of paperwork on the floor and a vintage robot working behind the desk

How did Robbie the Robot reap the benefits of automation?

  You probably keep hearing about the benefits of automation but wonder how they can help you and your business.  Whether you’re a one-person-band or a large organisation, automation can be a real game-changer, but it can feel like a big step when you’ve got a...
Blue background with electrical components arranged to look like robots with text overlay ‘Zapier Automation Project Showcase’.

Zapier Project Showcase

  We work with such a diverse range of clients, many of whom had never heard of Zapier before they connected with us.  We understand that you may be unsure what kinds of apps can be connected using Zapier so thought we’d share a showcase of some of our key...
Computer keyboard with a large blue Help button with the letters lit up and shining upwards.

How to get help with Zapier

If you’re just starting out and need some help with getting the best out of Zapier, or you’re simply stuck and don’t know where to turn, then we have some useful resources for you. Zapier’s Zap Editor has a help icon at the top (the blue question mark button) which...
Pages from a calendar with heading of ‘Four Day Week’ and a fountain pen.

How to make a 4 day working week more productive

Many UK businesses are participating in a 6-month pilot programme for their employees to work a four-day week but get the same pay and benefits that they would if they were full-time. It might sound too good to be true but the expectation is that increasing...
Automate ebook

Get our free ebook

Learn about how business process automation with Zapier can help you to run your business on autopilot. The ebook is packed with real-life examples, use cases, and success stories. Whatever kind of business you have, you can use automation to help you work smarter, not harder.

Thanks! Your ebook is on the way.

Pin It on Pinterest

Shares