Get WEEK of date in VBA

[Ragnar78]

Hy

Is their a way of retreiving the WEEK from date Field through VBA?
Just like the Year() function...

Thanks Agai

 

[Steve Schapel]

Ragnar,

Try this one...
DatePart("ww",[YourDateField])

 

[Douglas J. Steele]

Just to tag along on Steve's reply, note that there are a couple of optional
parameters you can provide to DatePart to control how it calculates what
week 1 is.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Ragnar,

Try this one...
DatePart("ww",[YourDateField])

--
Steve Schapel, Microsoft Access MVP

Hy

Is their a way of retreiving the WEEK from date Field through VBA?
Just like the Year() function...

Thanks Again