Calculate week number of month by given date in access

• revz_350

  SSC Veteran

  Points: 227

  More actions

  May 21, 2008 at 10:23 pm

  #72159

  I have a table has col (Name, ID, WeekNum, ProcDate)

  ProcDate is given date: ex: 02/13/08

  WeekNum: week 3 of the month in Feb

  ID | Name | WeekNum | ProcDate

  ------|---------|--------------|----------

  AG2Z | Jay, Lee | 3 |02/13/2008

  JP1D | DJ, Jose | ???? |04/11/2008

  PW9U | Tom, CJ | ????? | 05/13/2008

  how to do this in a access query? thanks..

• ~paul hewitt

  SSCommitted

  Points: 1933

  More actions

  May 22, 2008 at 2:43 am

  #819019

  Depending how you define a week number, the 'iso week' function here may help:

  http://www.cpearson.com/excel/weeknum.htm

  If the vba function does what you want, you could try putting it in an Access code module, then you can call it from an Access query.