I have a date. How to retrieve which week of the quarter it is in?
Example: 19 February 2024 is in week 4 of the quarter.
This is how I’ve done it, I didn’t extensively test it, but I think it’s correct.
quarter:
today:
weekOfYearQuarter (this calculates the week of the year of the quarter start date):
Final calculation weekOfQuarter:
Looking at your example, are you sure you want the quarter or month? Because today is the 8th week of the 1st quarter, not 4th
Oh yes, it’s the 8th. I will try this, thank you 