hi. how can i determine the work week number based
on the date inputted by the user?
for example, user selects May 27, 2013 (from a date picker),
and when he clicked the command button, it will display the work
week number. the result will be 22.

thanks in advanced.

Recommended Answers

All 3 Replies

you task can be done with DatePart function

MsgBox DatePart("ww", DTPicker1.Value)

hope this helps you . . .

thanks rishif2..it works..i thought it's complicated..thanks again..
til next tym.. :-)

marks this thread as solved

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.