Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What Week is it? (A2000)

    Hi All,

    This code will give me the results for everything in the previous month:

    Between DateSerial(Year(Date()),Month(Date()-1),0) And DateSerial(Year(Date()),Month(Date())-1,0)

    What will give me the results for the previous WEEK?

    Thanks.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: What Week is it? (A2000)

    If you mean during the last 7 days, use Between Date()-7 And Date()

    If you mean during the previous whole week starting on Sunday, use Between Date()-Weekday(Date())-6 And Date()-Weekday(Date())+1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •