Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Week of Month Calc

John Wallace
in Calculation Engine (Define Fields)

Featured Replies

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?

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...

Hi John,

Take a look at this discussion:

Click Here

HTH

Lee

  • Author

Hi guys, thanks for the input.

I knew I could count on this bunch.

Strange though, I did a search for "week of month" and found no posts about it.

Best regards,

John

Create an account or sign in to comment

https://fmforums.com/topic/18957-week-of-month-calc/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.