blackcat9000
Programmer
Hi there folks, I have another problem.
The formula below works out the week based on the date you put in
Me![scrweek] = Format(Date, "ww"
The problem is that say the date entered is 03/02/2004 (UK Format) the week result will show 6.
I want it to show 06.
Can anyone help?
Thanks in advance.
The formula below works out the week based on the date you put in
Me![scrweek] = Format(Date, "ww"
The problem is that say the date entered is 03/02/2004 (UK Format) the week result will show 6.
I want it to show 06.
Can anyone help?
Thanks in advance.