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