Results 1 to 5 of 5
  1. #1
    Crdmster is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    13

    Query Criteria - Date Range of This Week

    Is there a short and sweet way to add a criteria which only selects dates for the current week? I can't seem to find a way around having to hard type in the week start and end dates. If anyone knows a work around, any hints or advice would be appreciated.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    What is a current week, is it Sat-Sun or Mon-Fri or something else?

  3. #3
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Between Date() And Date()-7

  4. #4
    Crdmster is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    13
    For now it is Sat-Sun, but if I can figure out the criteria code for that then I'm sure I can edit it when the week start/end days change later. (It's safe to assume that if the week start/end days change at some point, it won't be a regular thing that will need adjusting).

  5. #5
    Crdmster is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    13
    Thanks aytee111! Seeing that gave me the push I needed. The below code works to sort all dates between Sun-Sat.


    Between (Date()-Weekday(Date()-7)) And (Date()+7-Weekday(Date()))

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

Similar Threads

  1. Replies: 9
    Last Post: 06-19-2015, 03:37 PM
  2. Replies: 3
    Last Post: 01-21-2015, 02:40 PM
  3. Replies: 9
    Last Post: 02-21-2014, 06:02 PM
  4. how to convert week number to date range
    By qwang1115 in forum Access
    Replies: 1
    Last Post: 02-13-2009, 11:35 AM
  5. Retrieving Week of Year in a date range
    By Korvega in forum Queries
    Replies: 2
    Last Post: 05-27-2006, 06:29 AM

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