I have a student records database where the student are separated into four different groups. The experiment for each group is decided by which week of the year it is. currently there is a name field, a group field, experiment field and a Week field. Currently the weeks (1-8) are selected manually from a pop-up menu. and the experiments assigned as a case clause for each week.

I want to automate the week selection process - I know term dates and therefore week numbers but I've hit a wall on this - any ideas

Welcome, chappers! There are two built-in functions:

https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help/weekofyear.html

WeekOfYearhttps://fmhelp.filemaker.com/help/16/fmp/en/FMP_Help/weekofyearfiscal.html

WeekOfYearFiscalIf you can get a number with one of these functions, then you can use the

Mod() function to 'group' them into 1 of the 8 groups:https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help/mod.html

So your groups will be 0, 1, 2, 3, 4, 5, 6, or 7, as Mod gives you the remainder after dividing. And you might get a group like this (adding 1 to the result):

Check a few dates to verify this will be ok for you.

Beverly