comparing dates (perl - mysql)

[cyber100]

Is there an easy way to calculate how many days between two dates..

i have two dates and want to work out how many days between them, i have a static date and was getting todays date then working out for each what the day of the year was and subtracting the two, this worked fine until the new year.. now i have dates from 2006 and todays date of 2007 and obviously cant use the day of the year function as the 2007 date is less than the 2006 date...

i simply want to calculate number of days from a date in the past to the current date...

last year i suffered a stroke and have forgot a lot of my programming so any help whatsoever would be greatly appreciated and will stop me banging my head against a wall which isn't good either...

thanks in advance
Cyber

[miller]

In perl, use the Delta_Days function from the Date::Calc module:

http://search.cpan.org/~stbey/Date-Calc-5.4/Calc.pod

use Date::Calc qw(Delta_Days);
 
      $Dd = Delta_Days($year1,$month1,$day1,
                       $year2,$month2,$day2);
 

In MySQL, use the DATEDIFF function

http://www.mysql.org/doc/refman/5.1/...functions.html

[cyber100]

Thanks mate, works a treat, many thanks