Converting dates to week number

[Sed]

Anybody knows how to convert dates to week number?

 

[namliam]

Lookup the "format" function

 

[Sed]

I don't understand. I have a field with all the dates in my query and I want to see if I can convert those dates into a week number

 

[Rabbie]

Look up the "Format" function in Access Help. You can use it to display a date as the week number.

 

[Alansidman]

Look at this earlier thread

http://www.access-programmers.co.uk/forums/showthread.php?t=100699

Alan

 

[raskew]

As was already pointed out, the Format() function will do it for you.

Something like this:

? date() 
11/10/2008 
? format(date(), "ww")
46

Bob

 

[Sed]

beautiful!!! it works thanks

 

[Sed]

Love you guys!!!