4 Replies Latest reply on Oct 13, 2009 10:17 AM by TSGal

    Find dates previous week



      Find dates previous week


      I would like to find dates from previous week.  I would like the week start on Sunday and end on Saturday.


      I found this code on filemaker website, but this looks like the dates would be Saturday through Saturday.


      What am I missing here


      // code from filemaker website


      Find all records that occurred last week (Sunday through Saturday)

      Create the following calculation (text result)

      (Get ( CurrentDate) - 7 - DayOfWeek (Get ( CurrentDate ))) & "..." & Get (CurrentDate ) - DayOfWeek (Get (CurrentDate )) 


      here is the url for this code