[AccessD] Week of the Month

Drew Wutka DWUTKA at marlow.com
Thu Jun 19 10:02:49 CDT 2003


Why not use the Day() function, to just show the day of the month, then
split it into 1 thru 7, etc.
 
Drew

-----Original Message-----
From: ACTEBS [mailto:actebs at actebs.com.au]
Sent: Thursday, June 19, 2003 9: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
 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030619/6d82f9b0/attachment-0001.html>


More information about the AccessD mailing list