Does anyone know of a way to use Zapier Formatter or other tool to get the week number from a date field or {{zap_meta_human_now}}?
How to use Formatter or other tool to get week number from date field
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
- 24150 replies
-
23 March 2022
Hi
Good question.
Can you clarify how you are counting the week numbers for a year?
What day of the week is considered the start? (Sunday or Monday)
What is considered the first week? (e.g. the week that has the 1st, or the week that has the first Thursday thus the 4 days and the majority of a week)
You’d likely have to use a Code step for this: https://zapier.com/apps/code/help
I also recommend submitting this as a feature request via a ticket to Zapier Support: https://zapier.com/app/get-help
I am looking for this exact solution as well. Any updates would be great. Thanks
Userlevel 7
+14
- Certified Zapier Expert
- 24150 replies
-
1 April 2022
Hi
Good question.
Really depends on how you determine weeks as there are a few different methods used.
- Can you clarify how you are counting the week numbers for a year?
- What day of the week is considered the start? (Sunday or Monday)
- What is considered the first week? (e.g. the week that has the 1st, or the week that has the first Thursday thus the 4 days and the majority of a week)
Thanks for the detailed inquiry on my need. Our week calendar starts on the first monday of January. This upcoming monday (4/4/2022) will be the start of our Q2.
Userlevel 7
+14
- Certified Zapier Expert
- 24150 replies
-
2 April 2022
A Code step can be used to calculate the week based on that logic: https://zapier.com/apps/code/help
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.