Week Numbers

[blackcat9000]

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&quot

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.

 

[zemp]

Have you tried,

Me![scrweek] = Format(Format(Date, "ww"),"00")

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[blackcat9000]

Thanks. that's exactly what i needed.