Form - Week Number

[gsandy]

I have a form with date formatted textbox (Week_Ending) and a number formatted textbox (Week_No). On exiting Week_No I wish to show the corresponding week number in Week_No using DatePart function. I wish to know the correct code (related to the two textboxes) and where to put the VBA code.

Thanks Sandy

 

[mikejaytlabustro]

Could you please take a screenshot of your form?

 

[burrina]

Example:

Me.Week_No = Format(Now(), "ww")

HTH

 

[mikejaytlabustro]

Week_No= DatePart("ww",[Week_Ending],1)
Note:
First day of the week
1=Sunday
2=Monday
3=Tuesday...

 

[gsandy]

Thanks Mike, your code worked just like I wanted it to. Cheers Sandy

 

[JHB]

Be aware of, the function not always return the correct weeknumber, special when Monday is the first day in a week.
http://support.microsoft.com/kb/200299