List:General Discussion« Previous MessageNext Message »
From:James Black Date:April 28 2005 2:43pm
Subject:re: determing number of Tuesdays within a date range
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a table with session information, with a start and stop time.

I can aggregate the information, grouping it by hour or weekday.

But, when I group it by hour and weekday, I need to also show the
average usage, so I need to figure out how many Tuesdays are contained
within 1/1/2004 - 5/1/2004, and I need to come up with a result where I
know how many of each day of the week is within that date range.

I am hoping someone may have a solution, as, once I know the number of
Tues then I can state the average number of sessions on a Tuesday at 4pm.

Thanx for any help.

- --
"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
James Black    james@stripped
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCcPaMikQgpVn8xrARAoSKAJ96AzRIgGXnjbn/Krlxehz7K/HTlgCfSXZe
VxslEjt9ERmUBiDJoBti3SE=
=bwx8
-----END PGP SIGNATURE-----
Thread
re: determing number of Tuesdays within a date rangeJames Black28 Apr
  • Re: determing number of Tuesdays within a date rangePeter Brawley28 Apr