Results 1 to 2 of 2

Thread: WeekNum

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: WeekNum

    Has anyone noticed that using the Format function with "ww" sometimes gives wrong values
    Try this
    MsgBox (Format(CDate("02.01.2005"), "ww")) it should result in 1, but it gives 2
    What do you mean?

  2. #2
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50
    I thing it depends what day you consider as first day of the week. If in US/UK, it may be Sunday, whereas in the rest of Europe it is Monday.

Posting Permissions

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