[AccessD] Week of the Month

Hi Vlad

Are you sure about this? Normally, an ISO standard, a week runs from
Monday to Sunday (except in the US where they start the week in the
middle of the weekend - go figure).

The DatePart() function and Weekday() will give the week and weekdays
if that is what you need (so you say). DatePart() is a little buggy
around week 52 but that won't probably be of importance to you.

/gustav


> Does anyone know of a method to work out what week it is of the month.
> For example, you have a range of  dates 1st January to 31st March. The
> 1st to the 7th is the 1st week of January and the 8th to the 14th is the
> second etc etc...
 
> I have 2.5 years of data (about 1 Million rows) from an old main frame
> system and we are trying to determine the frequency of delivery to each
> customer on a per monthly basis. So effectively to say customer Jim
> Spanner the client delivers every second Thursday for February. Is there
> an elegant method of working this out? I have the date the delivery was
> carried out for the past 2.5 years, but am having difficulty working out
> how I could manufacture a frequency pattern. 
 
> Is there any method anyone could suggest, that I could explore...