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

e.g.

=DCount("[ID]","[JHPclients]","Month([start date])=Month(Date())")

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" <(E-Mail Removed)> wrote in message
news:F0eeo.51818$r24.14610@hurricane...
>I can identify this month (Month(Date())) but how do identify this week?
>
> e.g.
>
> =DCount("[ID]","[JHPclients]","Month([start date])=Month(Date())")

great thanks

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:i5bsmf$130$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:F0eeo.51818$r24.14610@hurricane...
>>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" <(E-Mail Removed)> wrote in message
news:GCfeo.39930$Sr7.1505@hurricane...
> great thanks
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
> news:i5bsmf$130$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:F0eeo.51818$r24.14610@hurricane...
>>>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" <(E-Mail Removed)> wrote in
news:CLfeo.39931$Sr7.11076@hurricane:

> 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.

> "Chris K" <(E-Mail Removed)> wrote in message
> news:GCfeo.39930$Sr7.1505@hurricane...
>> great thanks
>>
>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in
>> message news:i5bsmf$130$(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:F0eeo.51818$r24.14610@hurricane...
>>>>I can identify this month (Month(Date())) but how do identify
>>>>this week?
>>>>
>>>> e.g.
>>>>
>>>> =DCount("[ID]","[JHPclients]","Month([start
>>>> date])=Month(Date())")
>>>
>>>
>



--
Bob Q.
PA is y I've altered my address.

"Chris K" <(E-Mail Removed)> wrote in
news:CLfeo.39931$Sr7.11076@hurricane:

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

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

I'll use that thanks

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9DE3A3C749234f99a49ed1d0c49c5bbb2@74.209.136.98...
> "Chris K" <(E-Mail Removed)> wrote in
> news:CLfeo.39931$Sr7.11076@hurricane:
>
>> 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")
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/