AnsweredAssumed Answered

Selecting a week number based on date

Question asked by chappers on May 7, 2018
Latest reply on May 17, 2018 by chappers

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