Results 1 to 2 of 2
  1. #1
    lucasjkr is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    7

    Select the First friday after a date

    Via a simply query, is it possible to select the first Friday after a given date?



    Say, if OrderDate is 11/10/2012 or 11/13/2012, then ShipDate would be 11/16/2012, or OrderDate is 11/17/2012, then ShipDate is 11/24/2012?

    Thank you!

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Assuming your Order Date Field is name ODate, in a query in a new field use this expression'

    SDate: DateAdd("d",Choose(Weekday([Odate]),5,4,3,2,1,7,6),[ODate])

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Select Date Range
    By dr4ke in forum Queries
    Replies: 8
    Last Post: 06-25-2012, 07:04 AM
  2. Replies: 14
    Last Post: 06-20-2012, 08:54 AM
  3. SELECT only this DATE RANGE (Pic Attached)
    By taimysho0 in forum Programming
    Replies: 1
    Last Post: 05-30-2012, 01:18 PM
  4. Getting the last and the next Friday
    By bonecone in forum Programming
    Replies: 9
    Last Post: 05-10-2012, 02:02 PM
  5. Select Query Using Different Date Ranges
    By Hemi426 in forum Queries
    Replies: 3
    Last Post: 07-26-2010, 01:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums