Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Find the previous weeks records

Last updated: before December, 1998

For the previous week (Sun - Sat): ('date'= your date field)

     if(weekofyear(date)=weekofyear(today())-1 and
          year(date)=year(today()))

If the data is only for one year, then you can leave out the 'and' and all that follows.
   
For the last 7 days: (including today)

     >=@TODAY()&<=@TODAY()+7
  
Or, if you need to find records produced during the last 7 days:

... starting with and including today's date, use the formula:

     >=@TODAY()&<=@TODAY()+7

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.