Return to FileMaker.com
How to calculate Start/End of Week
I have a subsummary report which uses a calculation of Year(dateField) & WeekofYear(dateField) to sort them.
Above each of these subsummary sections, I would like the section to be title such as:
1/1/2009 - 1/7/2009
The question is how do I calculate the start and end of a week (the dates)?
I dont suggest using a calc as such. Instead I would calculate what the first sunday of each week would be.
YourDate - DayOfWeek ( YourDate ) + 1
Here is a thread expanding upon this.
Retrieving data ...