Creating a sub summary of data by weeks that begin on Monday
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?