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.

Featured Replies

There's a calculation function for WeekOfYear, but not WeekOfMonth. I was trying to find a forum topic on it last week and didn't see one, then I came up with a solution that seems to work well.

First, create a field that calculates the first of the month for the given date in your original date field. So if the original date filed is called 'Date' and the new field is called 'FirstOfMonth':

FirstOfMonth = GetAsDate ( ( Month ( Date ) & "/" & "1/" & Year ( Date ) ) )

Then subtract the WeekOfYear for the FirstOfMonth field from the WeekOfYear for the Date field:

WeekOfYear ( Date ) - WeekOfYear ( FirstOfMonth ) + 1

The plus one is because a date in the first week of the month would be 1 - 1 so it cancels out. I hope someone else can find this useful. This forum has been very helpful to me so when I came up with a solution I couldn't find on here I wanted to share it and give something back. I know it's pretty basic but it's still useful.

Or you could use this calculation by Ugo Posted Here

(WeekOfYear(Date)+1)-WeekOfYear(Date(Month(Date);1;Year(Date)))

  • Author

Even better- that does it all in one calculation instead of using two fields. Thanks :)

Create an account or sign in to comment

Important Information

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

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.