AnsweredAssumed Answered

Creating a sub summary of data by weeks that begin on Monday

Question asked by MarkRingwald on Mar 21, 2012
Latest reply on Mar 21, 2012 by MarkRingwald

Title

Creating a sub summary of data by weeks that begin on Monday

Post

I am pretty new at this and searched the forum where I came up with this calculation for a field I called Weekly:

DateField - DayofWeek(DateField) + 2  for a Monday-Sunday week.

I created Sub-summary report based on this field and sorted it by that field. It works except that it includes the Sunday prior to the Monday I want the week to begin with. Is there a way to get Filemaker to recognize Monday as the first day in the week?

Outcomes