[RESOLVED] Best way to compare dates

[mrgrammar]

What is the best way to compare two dates? For example, I have two dates in mysql date format (yyyy-mm-dd).

$currentdate = date('Y-m-d');
$expiredate = '2010-03-21';

I want to know if the expire date is less than or equal to the current date. What is the best way to do that?

[anakadote]

if(strtotime($expiredate) <= strtotime($currentdate)){
   // Expired
}

[mrgrammar]

anakadote;10966905 wrote:

if(strtotime($expiredate) <= strtotime($currentdate)){
   // Expired
}

Can you use BETWEEN to check to see if it is between particular dates or do you have to do two comparisons?

$currentdate = date('Y-m-d');
$startdate = '2010-01-27'
$expiredate = '2010-03-21'; 


if(strtotime($expiredate) > strtotime($currentdate) || strtotime($expiredate) < strtotime($startdate)){
   // Expired
}

[NogDog]

If you can do it as part of your database query, you can use the BETWEEN operator in MySQL.

[mrgrammar]

Unfortunately, the date range is not stored in the database. However, your reply gave me an idea. Thanks for the suggestion.