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 year (date)

60minuteman
in The Left Brain

Featured Replies

I have a booking database that assign a week of year number to bookings based on their dates,the problem is that weeks in the uk run from monday to sunday,so week 8 would be mon16/2/04 to sunday22/2/04 but filemaker is putting sunday22 as the start of week 9 not the end of week 8,is their a simple work around

filemaker pro 4 mac g4 os9.0

Hi,

Have a try with :

(WeekOfYear(date- WeekOfYear(date-1)))

  • Author

where do i put my field name pick up date in there?

ie i have fileld definition

week of year calculation indexed, weekofyear(pickupdate)

Just replace the 2 instances of date in Ugo's calculation with pickupdate

HTH

Ed.

Create an account or sign in to comment

https://fmforums.com/topic/20252-week-of-year-date/
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.