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 nicksimard
View original
Google calendar - filter by day (i.e., Monday or Sunday)?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 23940 replies
-
9 May 2022
Userlevel 7
+11
- Zapier Staff
- 2116 replies
-
10 May 2022
- Answer
Hi
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!
- Beginner
- 19 replies
-
10 May 2022
I have already tried that but there is not filter (that I can see) that filters on day-as-string?
- Beginner
- 19 replies
-
10 May 2022
Hi
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.