I can identify this month (Month(Date())) but how do identify this week?

  • Thread starter Thread starter Chris K
  • Start date Start date
C

Chris K

I can identify this month (Month(Date())) but how do identify this week?

e.g.

=DCount("[ID]","[JHPclients]","Month([start date])=Month(Date())")
 
can it be called once to return week & year

DatePart("ww,yyyy", Date())

or would i need to call it twice to return both?



Chris K said:
great thanks

Douglas J. Steele said:
DatePart("ww", Date())

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele/AccessIndex.html
Co-author: "Access 2010 Solutions", published by Wiley
(no private e-mails, please)


Chris K said:
I can identify this month (Month(Date())) but how do identify this week?

e.g.

=DCount("[ID]","[JHPclients]","Month([start date])=Month(Date())")
Click to expand...
Click to expand...
Click to expand...
 
can it be called once to return week & year

DatePart("ww,yyyy", Date())

or would i need to call it twice to return both?
Click to expand...
DatePart works on a single interval. There is no DateParts()
function.
But Format([somedate],"ww,yyyy") will format the date as you want it.
Chris K said:
great thanks

Douglas J. Steele said:
DatePart("ww", Date())

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele/AccessIndex.html
Co-author: "Access 2010 Solutions", published by Wiley
(no private e-mails, please)


I can identify this month (Month(Date())) but how do identify
this week?

e.g.

=DCount("[ID]","[JHPclients]","Month([start
date])=Month(Date())")
Click to expand...
Click to expand...
Click to expand...
 
can it be called once to return week & year

DatePart("ww,yyyy", Date())

or would i need to call it twice to return both?
Click to expand...

You should look at Format():

Format(Date(), "ww, yyyy")
 
Back
Top