locked
I need to convert a date to a week number RRS feed

  • Question

  • I need to convert a date to a week number in an access Table.
    • Edited by BillatTECI Wednesday, October 9, 2013 4:45 PM
    Wednesday, October 9, 2013 4:31 PM

Answers

  • If you want to display the date as a week number, set the Format property of the date field to ww.

    If you want to return a number that you can use in calculations, create a query based on the table, and add a calculated column

    Weeknum: Val(Format([DateField],"ww"))

    where DateField is the name of the relevant date field.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, October 9, 2013 6:41 PM