FW: CALCULATING DATES

2004-01-28 Thread Paul Hayer
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,

CALCULATING DATES

2004-01-28 Thread Paul Hayer
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