Get WEEK of date in VBA

  • Thread starter Thread starter Ragnar78
  • Start date Start date
R

Ragnar78

Hy

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

Thanks Agai
 
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!)


Steve Schapel said:
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
Click to expand...
Click to expand...
 
Back
Top