Skip to main content
Best answer

Google calendar - filter by day (i.e., Monday or Sunday)?


Forum|alt.badge.img
  • Beginner
  • 19 replies

I would like my Zap (that copies events between two calendars) to only apply on Google Calendar events that takes place on weekends (Saturdays and Sundays). Is it possible to filter on day-of-week?

Best answer by nicksimardBest answer by nicksimard

Hi @dbo!

To add onto what troy suggested, in order to filter for weekends you’d first have to format the date so that it gives you the day of the week (you can use Formatter by Zapier):

 

After this step you would add your filter:

 

 For the To Format field you’ll want to do it this way:

 

And you don’t need anything in the From Format field. BUT, you’ll probably want to change the timezones, since that will affect which day will be output.

Hope that helps!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @dbo 

Good question.

Try adding a Filter step in your Zap: https://zapier.com/apps/filter/help


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • Answer
  • May 9, 2022

Hi @dbo!

To add onto what troy suggested, in order to filter for weekends you’d first have to format the date so that it gives you the day of the week (you can use Formatter by Zapier):

 

After this step you would add your filter:

 

 For the To Format field you’ll want to do it this way:

 

And you don’t need anything in the From Format field. BUT, you’ll probably want to change the timezones, since that will affect which day will be output.

Hope that helps!


Forum|alt.badge.img
  • Author
  • Beginner
  • 19 replies
  • May 10, 2022
Troy Tessalone wrote:

Hi @dbo 

Good question.

Try adding a Filter step in your Zap: https://zapier.com/apps/filter/help

I have already tried that but there is not filter (that I can see) that filters on day-as-string?


Forum|alt.badge.img
  • Author
  • Beginner
  • 19 replies
  • May 10, 2022
nicksimard wrote:

Hi @dbo!

To add onto what troy suggested, in order to filter for weekends you’d first have to format the date so that it gives you the day of the week (you can use Formatter by Zapier):

 

After this step you would add your filter:

 

Hope that helps!

I tried this but when I enter “dddd” it’s replaced by “Dddd”.

 

Here is how my formatting steps are setup:

1.

 

2.

 

 

But when I test the step, I get this result:

 

Any ideas why?

Thank you for your help.