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

you task can be done with DatePart function

MsgBox DatePart("ww", DTPicker1.Value)

hope this helps you . . .

Jump to Post

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.