4 Replies Latest reply on Mar 21, 2012 4:24 PM by MarkRingwald

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

    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?