How to filter out weekends events on Google Calendar?

Question

Hi follow Zapers,

I have created a Zap that, everytime I create an activity in my private calendar, it will send an invite to my work calendar. I placed a filter in between, so that it will only process activities between 9am and 5pm.

So far so good, but I need some assistance with the following:

I’d love to be able to filter on days of the week, in order to filter out weekends and my part time day off. Unfortunately, google calendar does not include the specific day in their API export, that would have been easy.

Any thoughts on how to do a work around?

Thanks!

mzsadiek · Accepted Answer

Hi @Pairis! You will need to use ‘Formatter by Zapier’, and select ‘Date/Time’.

Use the date as the input. In ‘To Format’ type in a custom value ‘dddd’ which gives you the name of the day. Make sure the timezones are set correctly, and the ‘From Format’ also.

This gives you the ability to make a filter that only continues when the output is not Saturday and not Sunday :)

Hope this helps.

Pairis · Answer

Thank you @mzsadiek!This was really helpful!

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded