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

    Find dates previous week

    deliciousapple

      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