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, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & 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 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 calculate by a month forward. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]