week of year (date)

[60minuteman]

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

[Ugo DI LUCA]

Hi,

Have a try with :

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

[60minuteman]

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

ie i have fileld definition

week of year calculation indexed, weekofyear(pickupdate)

[EddyB]

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

HTH

Ed.