[AccessD] Week of the Month

I would have thought that simply integer division of the day of the month by
seven would suffice.

WkOfMonth = Day([DeliveryDate]) \ 7 + 1

Lambert

> -----Original Message-----
> From:	ACTEBS [SMTP:actebs at actebs.com.au]
> Sent:	Thursday, June 19, 2003 10:52 AM
> To:	access group
> Subject:	[AccessD] Week of the Month
> 
> Guys,
>  
> 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...
>  
> AHGA
>  
> Regards
> Vlad
>  
>   << File: ATT5220503.txt >>