Funktion for the Week Number

[Schlingel]

Hi,
I will really appreciate ur help. I work on Access-2000 database and have a problem. I need to get the number of the week. So i used the funktion as a standard value as following:
"=((Monat(Datum())*30,5-Tag(31-Datum()))/7)"
It shows me for today 39 instead of 44.
Could u please help me and tell me why this funktion doesnt work?
Thanks in advance

 

[PeterF]

Why not use the format function?

=format(date(), "WW")

 

[Schlingel]

Thanks for this reply. But to use this funktion i have to write a VBA code, haven't i? And i am really a newbie. Could u give me a little bit more of instructions? Cause if i use the funktion u gave me as a standard value, the access writes "Syntax error". And if i write a code, then i get 43 instead of 44...
Again, thanks in advance

 

[Alan R]

Shouldn't it be:

=format(Now(),"ww")

 

[Schlingel]

Thanks 1000 times! I found out the right code and now it's ok!!! Thanks Thanks Thanks. By the way, i checked with Now() and Date() and it works super in both ways!!! Thanks again

 

[gemma-the-husky]

may i chip in,

that's wonderful, i never realised you could do that with dates. I spent ages constructing a weekly lookup table to do that, and it still doesn't have that the overall functionality of the format function.