Determine start date of week and end date of week based on WeekOfYear
I'm creating a Filemaker application that allows my staff to enter their time for each day. The staff member will enter the date that they are entering time for and I'm able to find the WeekOfYear to determine which week in the year is that entry date in. What I want to do is determine (calculate) what the starting date of that particular week is and what the ending date of that particular week is. This is needed for two reasons: (1) it helps the staff member quickly identify the week they are entering time for, and (2) it will help in creating reports that break down the time entered per week. Can't quite figure out how to get the week start date and the week end date based upon the week of the year.
DateField - DayOfWeek (DateField ) + 1
Will return the date for Sunday of the same week.
DateField - DayOfWeek (DateField ) + 7
Will return Saturday