week of the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do we find the week of the month and not the year

e.g. Week1 (2nd May - 8th May) and how to include weekdays falling in the
next month.

Any help would be appreciated

Thanks a bunch

binny
 
Binny,

I was searching to find a "simple" answer to your question. I am not sure
exactly how you are going about it but try this.

Say your field is called "date" and you drag it to where it says field in
your query. Right click on it and hit build. In your expression builder
type this, My Date:Format([date],"ww"). You probably know this but you
can't use the same name such as Date:Format([date],"ww") as you will get a
circular referance.

I am by no means an expert so if there is a better way then someone will
hopefully correct me. This should work though. Let me know how it goes.

-Chuck
 
Chuck said:
Binny,

I was searching to find a "simple" answer to your question. I am not
sure exactly how you are going about it but try this.

Say your field is called "date" and you drag it to where it says
field in your query. Right click on it and hit build. In your
expression builder type this, My Date:Format([date],"ww"). You
probably know this but you can't use the same name such as
Date:Format([date],"ww") as you will get a circular referance.

I am by no means an expert so if there is a better way then someone
will hopefully correct me. This should work though. Let me know how
it goes.

-Chuck
Click to expand...

Ciao I'm Massimiliano, newbie on this NG.
Format for the date has a bug for last monday of the year.
So i

--
_ _
Ciao
MAssimiliano Amendola
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Chuck said:
Binny,

I was searching to find a "simple" answer to your question. I am not
sure exactly how you are going about it but try this.

Say your field is called "date" and you drag it to where it says
field in your query. Right click on it and hit build. In your
expression builder type this, My Date:Format([date],"ww"). You
probably know this but you can't use the same name such as
Date:Format([date],"ww") as you will get a circular referance.

I am by no means an expert so if there is a better way then someone
will hopefully correct me. This should work though. Let me know how
it goes.

-Chuck
Click to expand...


Sorry I souted the mail too early
J repeat
Format(date,"ww") has got a bug
http://support.microsoft.com/?kbid=200299

better datepart("ww", yourdate)


--
_ _
Ciao
MAssimiliano Amendola
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
And there you have it. Thanks MA I wasn't aware of a bug.
 
Back
Top