Week number

Results 1 to 2 of 2

Thread: Week number

  1. #1
    Join Date
    Dec 1969

    Default Week number

    How can we get week number in access. Say now we are in the third week it should say 3..Is it possible in the first place<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Week number

    Week number of the year or of the month?<BR><BR>Year is easy, just use DatePart with &#039;ww&#039;.<BR><BR>Week number of the month is a teeny bit more complicated, but given that you know the date, and you know how many days there are in a week, a bit of division should do the trick.

Posting Permissions

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