AnsweredAssumed Answered

Find dates previous week

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

Title

Find dates previous week

Post

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

 

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=4837&p_created=1115172885&p_sid=gfugc6Jj&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9Niw2JnBfcHJvZHM9ODY0JnBfY2F0cz0mcF9wdj0xLjg2NCZwX2N2PSZwX3BzX2Fuc191cGRhdGVkPSZwX3BhZ2U9MSZwX3NlYXJjaF90ZXh0PWZpbmQgcmVjb3JkcyBwcmV2aW91cyB3ZWVr&p_li=&p_topview=1 

Outcomes