MAIL PROTECTED]
-Original Message-
From: Paul Hayer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 28 January, 2004 6:14 PM
To: '[EMAIL PROTECTED]'
Subject: FW: CALCULATING DATES
Thanks for the reply,
I think SUM(DAYOFYEAR) has solved it. However is there a way of subtracting
weekends
t: 28 January 2004 15:08
To: Paul Hayer; [EMAIL PROTECTED]
Subject: RE: CALCULATING DATES
Hi,
You can use TO_DAYS() and FROM_DAYS() functions for what you need.
All details about Time and Date functions :
http://www.mysql.com/doc/en/Date_and_time_functions.html
Regards,
& SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
-Original Message-
From: Paul Hayer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 28 January, 2004 4:46 PM
To: '[EMAIL PROTECTED]'
Subject: CALCULATING DATES
Hi,
I want to be able to show the total of the
Hi,
I want to be able to show the total of the subtraction of the "returned
date" from the "from date" for each department for each month.
This to be done on a range of a year, and then when the next month comes
round for the calculation to take that month into account, so, shifting the
range to