AnsweredAssumed Answered

Find dates previous week

Question asked by deliciousapple on Sep 28, 2009
Latest reply on Oct 13, 2009 by TSGal


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