+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

There is another useful date/time function in Zapier which returns the current date/time.  You can use it to insert the time a zap runs into a field – for display purposes maybe, or to use in another step of the zap.

For this purpose, you can use the function {{zap_meta_human_now}}.  It returns a human-readable date/time based on the default time zone in your profile.

There are other functions which return machine-readable timestamps for the current date/time, including {{zap_meta_timestamp}} and {{zap_meta_utc_iso}}.

Whilst these may only be used by more experienced Zapier users, it’s worth knowing they exist as they could come in useful one day.

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

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...
Solvaa blog header image: Automate sales and marketing to make your holidays more jolly

Marketing and Sales Automations to Make Your Holidays More Jolly

Between Black Friday, Thanksgiving, and the holidays, November and December are busy times for businesses. Your busiest days may be yet to come, but if you want to get ahead, you need to start preparing as soon as possible. This post offers tips for automating and...
Wooden blocks spelling 'LEARN' on a wooden surface with plain blocks in the foreground and background.

Free checklist to help you justify an automation learning budget

If you’re keen to learn more about automation then it’s likely you’ll need to justify the budget with your boss.   You may be competing with many other requests for finance so it’s vital to ensure you have a good business case. So where do you start?   We have the...
How-IQ-Glass-saves-45-hours-per-week-with-Zapier-automations : Blue graphic with text “Client Success Story: How IQ Glass saves 45 hours per week with Zapier Automations” over a background of a glass wall with blue/grey frames.

Client Success Story : How IQ Glass saves 45 hours per week with Zapier automations

We love to share our success in helping clients improve their business because it demonstrates how spending a little time on process improvement and automation can deliver massive results. IQ Glass is a great example of this, a business that had put all the right...
Closeup of a section of a light grey keyboard with a blue ‘Organise’ button. Solvaa logo in top right hand corner.

How to organise your zaps

If you’re a new Zapier user then learning how to organise your zaps will help you manage them efficiently from Day 1.  As an existing Zapier user, if your zaps aren’t organised then you may find that it gets harder and harder to find the zap you’re looking for....
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...
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...
Flatlay with notebooks and pens, plant, glasses and text overlay which says ‘Supercharging Productivity With Automation Masterclass’

Free Masterclass: Supercharging Productivity With Automation

  Our Chief Problem Solver, Kelly, recently had the pleasure of speaking at the Practically Perfect virtual summit for assistants, talking all about the tools and technologies which can help VAs, executive and personal assistants to boost efficiency. If you’re a...
Wooden desk with a laptop, phone and stationery with blue square featuring the text “How to send a daily digest of all paid Xero invoices using Slack”

How to send a Slack message with a daily digest of paid Xero invoices

Using Zapier to send a Slack message with a daily digest of paid Xero invoices can provide useful data which is sent to your team automatically.  Knowing when invoices have been paid is business-critical information, but it can be time-consuming to check your...
: A laptop and plants on a wooden desk with grey wall, with text overlay saying ‘save contact form submissions in a spreadsheet’.

How to automatically save contact form submissions in a spreadsheet

If you use a form on your website for visitors to contact you then you will usually get their details emailed to you so that you can then respond.  Whilst this works adequately as a lead notification system, what would be more useful is to save contact form...
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. ...
The head image for the blog post showing a photo of a calendar on a yellow background. Next to the calendar is the Solvaa Automation academy & consultancy logo. Under that are the logos for the Calendly and Zapier apps.

Create a Zap for rescheduled Calendly events by adding one simple step

When you're using Zapier, it can be frustrating if the trigger or action you need doesn't exist. If you're technically minded, you may be able to build your own, but sometimes there's a simpler solution. If you're using Calendly with Zapier, you'll know that there...
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...
Male businessman with a tablet in his hand and icons representing business process automation floating above it.

How to get started with automation and work smarter, not harder

Are you feeling overwhelmed by your to-do list? Do you feel like you're working all the time but not getting anywhere? If so, it might be time to start using automation to help lighten the load. Automation helps you work smarter, not harder, and in this blog post...
Turquoise letters of the alphabet flying around randomly.

How to unlock the power of Zapier’s text formatter

If you haven’t used Zapier’s inbuilt text formatting function then you may be surprised by just how powerful it is.  Many zaps process character data in one form or another, and if the data isn’t ‘clean’ then it won’t look neat when it’s output onto invoices, used in...
Image showing a flatlay laptop with bulldog clips on a white background with overlaid text in a blue section which says “Add contacts to your email marketing tool from your CRM”.

How To Automatically Add Contacts To Active Campaign From Pipedrive

It’s never been more important to keep in touch with customers, and if you’ve ever wondered how to automatically add contacts to Active Campaign from Pipedrive then we have a really simple solution. As many CRMs don’t have built-in email marketing modules there are a...
Blog title image "There's an app for that, but do you need it?"

There’s an app for that, but do you need it?

From lead management to turning on the office coffee machine, there's an app for everything these days. When a task or process is time-consuming or difficult, it can be easy to jump straight to looking for something to do it for you. It's worth taking time to pause...

How to automate thanking your customers for paying their Xero invoices

Learning how to automate sending an email using Zapier when a Xero invoice is paid is a really simple but useful workflow that saves time and provides great customer service. Xero is a cloud-based accounting system which includes a host of features to reduce...
A calculator with some graphs and charts to measure the financial position of a business. A colourful 3D pie chart sits on top of the reports.

How to automate your finance and reporting processes to help your business grow

If your business is growing quickly then it can be tricky to deal with the increased accounting transactions you receive as a result of more sales. On the one hand, this sounds like a lovely problem to have, but if you don't streamline your financial processes then...

How to automate adding invoices to Xero from Pipedrive

If you use a Customer Relationship Management (CRM) app in your business, it is often a common workflow requirement to create an invoice in your accounting system once a deal or opportunity reaches a certain stage in the CRM. If an integration exists between your two...
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