How get week number in a text box on a report
Posted on 2012-12-29
On a report I have 52 text boxes arranged vertically. In the first box I want the value of the textbox to be the 1st week of the year's number (1). In the next textbox I want the 2nd week of the year's number (2). So the end result will be:
I could be using labels to designate the value but the reason I need a calculated value is because I'm going to use that value in a formula in another textbox to the right of each week's number textbox.
Make sense? What is the control source I need to enter to get the week number?
I tried = DatePart(“ww”,Date(#01/01/2012#)) but obviously that isn't working.