Since you've defined your own algorithm for calculating the number of
weeks between 2 dates, i suggest you just write up the routine... it's
a pretty simple thing to do... sounds like all you really need to do is
do the diff, come up with an number and conditionally add 0, 1 or 2
depending on which day of the week your start day and end day fall on.
/John
Tom Ferguson wrote:
ah, ok... I see. Figured it had
to be something
I guess because I need the
number of weeks including partials, so for example if The first date
was August 6 2005 and the second was August 28th 2005, @DATEDIFF would
return 22. 22 divided by 7 is a little more than 3 and the actual weeks
that date range touch would really be 5 so dividing by 7 doesnt give me
what i need.
Thanks though,
Brian
??
why not calculate the number of
days and divide by 7?
Am I missing something?
Is there anyway to calculate
the number of weeks between 2 given dates, similar to how you get the
number of days between two dates using @datediff?
I can do it by formating the
two dates into a numerical week value and calculating the difference,
but this won't work if its spanning years, any advice would be helpful.
Thanks
Brian
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|
