Results 1 to 4 of 4
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Extrapolate a Date in Query (XP / SP2)

    I have 2 tables. One contains the hours that people worked showing the actual week date
    (03/29/03, 04/05/03, 04/12/03). I have another table that has the list of closing dates for the
    bi-weekly payroll (03/29/03, 04/12/03, 04/26/03).

    I am trying to write in my query a way to extrapolate the date of the intermediate week of the
    pay period. The criteria for bringing back the date for the 2nd week of the period is

    <pre>>Date()-Weekday(Date(),0)-7 And <Date()</pre>

    .

    On my report, I will have to show the hours for both weeks and the total of the 2.

    Thanx!
    Alan

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

    Re: Extrapolate a Date in Query (XP / SP2)

    Alan,

    I don't understand what your purpose is. You already have all the "week dates" in one table. Do you want to compute the "week date" that falls within 7 days of today, or ...? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>. Perhaps you can give an example of the result you exect to get.

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Extrapolate a Date in Query (XP / SP2)

    Or perhaps I am nuts and I do not know what I want?

    I thought I needed 2 queries; 1 for the first week and 1 for the second. Stupid idea!
    My query brings back all the dates. I will have the person requesting the report to
    supply the 2 dates to display in the report. Actually, this requirement will satisfy an
    option they wanted for Phase 2.

    Sorry to bother... <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>
    Alan

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

    Re: Extrapolate a Date in Query (XP / SP2)

    Don't worry, in many cases trying to explain a problem to others enables you to solve it yourself.

Posting Permissions

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