Jump to content

Week of Month Calc


This topic is 7542 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to calculate the week of the month for a date. For the purposes of this post, weeks are Sunday thru Saturday. November 1 is a Saturday and would be in Week 1. Nov. 2 is Sunday and would be in Week 2. Nov 3 is Monday and would be in Week 2. Nov 30 is a Sunday and would be in Week 6.

How do I calculate on the fly the Week of the month for any given date?

Link to comment
Share on other sites

Use the WeekofYear for your record's main date, and the WeekofYear for the first day of that month (which is day(Date)-Day+1)...

Something like:

WeekofYear(date)-(WeekofYear(date-(Day(date))+1))+1

The +1 thing is necessary because subtracting the day# from any date would get you one day too far back. Same with subtracting the week number of the first of the month from the week number of your date in question...

Link to comment
Share on other sites

This topic is 7542 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.