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

[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())")

 

[Douglas J. Steele]

DatePart("ww", Date())

 

[Chris K]

great thanks

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())")

 

[Chris K]

can it be called once to return week & year

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

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

great thanks

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())")

 

[Bob Quintal]

can it be called once to return week & year

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

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

DatePart works on a single interval. There is no DateParts()
function.
But Format([somedate],"ww,yyyy") will format the date as you want it.

great thanks

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())")

 

[David W. Fenton]

can it be called once to return week & year

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

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

You should look at Format():

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

 

[Chris K]

I'll use that thanks

You should look at Format():

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