Results 1 to 5 of 5

Thread: w/e date

  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: w/e date

    I want to run query and use this criteria, but not sure how to put it in.

    Lets say the pay period ends on 12/1/06 I want a prompt to ask me the week ending and include the previous 6 days. So it will include 12/1/06 and the 6 days before that.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can use the DateAdd() function to subtract 6 days from the given date.
    Paul

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    so it would be like this?

    [W/E Date]
    DateAdd(d,6[W/E Date])

    didn't work.

    right now i'm doin
    Between [Beginning Date] And [Ending Date]

    Its always 7 day. I just wanna make it so you enter the Ending Date
    Last edited by Jay59; 12-07-06 at 17:14.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    more like:

    Between DateAdd("d",-6,[Ending Date]) And [Ending Date]
    Paul

  5. #5
    Join Date
    Sep 2006
    Posts
    162
    Thanks bro, much appreciated.

Posting Permissions

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