<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Guys,</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>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...</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2></FONT></SPAN><SPAN
class=610101010-19062003><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>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.
</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>Is there any method
anyone could suggest, that I could explore...</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>AHGA</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Vlad</FONT></SPAN></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV></BODY></HTML>