Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Returning Dates using today's date + 5

Discussion in 'Information Technology' started by PPCO, Jul 28, 2006.

  1. PPCO

    PPCO
    Expand Collapse
    Guest

    I am doing an order schedule and would like to see all orders less than/equal
    to today's date + 5 Weekdays. I have it working for today's date + 5 days but
    not for 5 weekdays.
    My current sql is: <=Date()+5

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    Christianity The Path of Returning to God Interfaith Dialogues Feb 6, 2011
    Returning to SPN Announcements Nov 2, 2006
    Returning to sikhi, actually... Announcements Feb 14, 2006
    Christianity will religions join with the returning of Jesus? Interfaith Dialogues Jun 28, 2005
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    PPCO wrote:
    > I am doing an order schedule and would like to see all orders less
    > than/equal to today's date + 5 Weekdays. I have it working for
    > today's date + 5 days but not for 5 weekdays.
    > My current sql is: <=Date()+5
    >
    > Thanks


    I think this from the help file may help.


    Uses the DateAdd function to display a date that is 10 days before the value
    of the PromisedDate field.

    =DateAdd("y", - [PromisedDate])10


    --
    Joseph Meehan

    Dia duit
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:yUCsg.21855$vl5.11823@tornado.ohiordc.rr.com...
    > PPCO wrote:
    > > I am doing an order schedule and would like to see all orders less
    > > than/equal to today's date + 5 Weekdays. I have it working for
    > > today's date + 5 days but not for 5 weekdays.
    > > My current sql is: <=Date()+5
    > >
    > > Thanks

    >
    > I think this from the help file may help.
    >
    >
    > Uses the DateAdd function to display a date that is 10 days before the

    value
    > of the PromisedDate field.
    >
    > =DateAdd("y", - [PromisedDate])10


    Or, more correctly:

    =DateAdd("y", -10, [PromisedDate])


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)
     
  5. PPCO

    PPCO
    Expand Collapse
    Guest

    I don't think I explained clearly enough what I was trying to do. I want to
    be able to see orders that that are scheduled for the next 5 weekdays. I also
    need to be able to see open orders before today's date (because some have not
    been completed and shipped). My current SQL returns orders for the next 5
    days (including weekends) but not for just the next 5 weekdays. Thanks!

    "Douglas J Steele" wrote:

    > "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    > news:yUCsg.21855$vl5.11823@tornado.ohiordc.rr.com...
    > > PPCO wrote:
    > > > I am doing an order schedule and would like to see all orders less
    > > > than/equal to today's date + 5 Weekdays. I have it working for
    > > > today's date + 5 days but not for 5 weekdays.
    > > > My current sql is: <=Date()+5
    > > >
    > > > Thanks

    > >
    > > I think this from the help file may help.
    > >
    > >
    > > Uses the DateAdd function to display a date that is 10 days before the

    > value
    > > of the PromisedDate field.
    > >
    > > =DateAdd("y", - [PromisedDate])10

    >
    > Or, more correctly:
    >
    > =DateAdd("y", -10, [PromisedDate])
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    >
     
  6. Al Camp

    Al Camp
    Expand Collapse
    Guest

    PPCO,
    Do you have any transactions on Sat or Sun?
    If not, cvouldn't you just ask for the next seven days.
    That would pick up the next 5 workdays, with no data reported for Sat and Sun.

    Have you looked at the Weekday function? You could ask for seven days ahead, and
    filter out those dates where the Weekday is NOT 1 or 7.

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions


    "PPCO" <PPCO@discussions.microsoft.com> wrote in message
    news:33970019-AED0-4547-BB0F-B37C3ACDCEF5@microsoft.com...
    >I don't think I explained clearly enough what I was trying to do. I want to
    > be able to see orders that that are scheduled for the next 5 weekdays. I also
    > need to be able to see open orders before today's date (because some have not
    > been completed and shipped). My current SQL returns orders for the next 5
    > days (including weekends) but not for just the next 5 weekdays. Thanks!
    >
    > "Douglas J Steele" wrote:
    >
    >> "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    >> news:yUCsg.21855$vl5.11823@tornado.ohiordc.rr.com...
    >> > PPCO wrote:
    >> > > I am doing an order schedule and would like to see all orders less
    >> > > than/equal to today's date + 5 Weekdays. I have it working for
    >> > > today's date + 5 days but not for 5 weekdays.
    >> > > My current sql is: <=Date()+5
    >> > >
    >> > > Thanks
    >> >
    >> > I think this from the help file may help.
    >> >
    >> >
    >> > Uses the DateAdd function to display a date that is 10 days before the

    >> value
    >> > of the PromisedDate field.
    >> >
    >> > =DateAdd("y", - [PromisedDate])10

    >>
    >> Or, more correctly:
    >>
    >> =DateAdd("y", -10, [PromisedDate])
    >>
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >>
    >>
     

Share This Page