How do i know which is the later date? MSSQL?

[adrian_quah]

How can i know which dates are later as seen in my code below. I am using MS SQL Database and the fields mentioned are of type
datetime .

---

<?php
if (($qr_case["Date_Close"]) > ($qr_case["Target_Closed_On"]))
{
echo "Date Close bigger than Target Date";
}
else
{
echo"Target Date bigger than Close Date";
}

?>

where the:-
$qr_case["Date_Close"]
$qr_case["Target_Closed_On"]
are valid dates from the format datetime in an MS SQL db.

Thanks guys.

[joe2]

use php date and maktime functions.........

[adrian_quah]

Allrite, thought there might hav been another way. Thanks Joe!