Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    1

    Retrieving Week of Year in a date range

    I've been trying to run an Expression on a date range to display the week of the year for a selected date. I thought this was possible with the DatePart function but I'm not having any luck with it. If anyone has any tips I'd appreciate it.

    Thanks!


    Korvega

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Datepart should do it. For example

    DatePart("ww",#5/10/06#)

    returns 19

  3. #3
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Korvega,

    John gave you an excellent start. To finalize the answer, though, you must define exactly how to define the week number. Does Week 1 start with:

    First day of the year?
    First Sun/Mon/Tue/Wed/Thu/Fri/Sat of the year?
    Something else?

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

Similar Threads

  1. Changing a date to the current year
    By fdnyfish in forum Access
    Replies: 1
    Last Post: 03-01-2008, 08:34 AM
  2. Continuous Range of Records
    By tigers in forum Access
    Replies: 0
    Last Post: 10-10-2007, 08:36 AM
  3. Finding data between two date for any year
    By gemini2 in forum Access
    Replies: 4
    Last Post: 04-05-2006, 06:20 AM
  4. Day of Week Totals
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 03-18-2006, 07:01 PM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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