Date Comparision

[obrienkev]

Hi all,

I have a date from a html form and I want to compare it with dates in a SQL Server Database.

The html form date has this format: YYYY-MM-DD

And I formatted the Database date to this: YYYY-MM-DD

So is the below the correct way of checking if the dates clash? Thanks.

if(($class_start >= $date_start_db) && ($class_start <= $date_end_db)
|| ($class_end > $date_start_db) && ($class_end <= $date_end_db)
|| ($class_start <= $date_start_db) && ($class_end > $date_start_db))

[liquorvicar]

What do you mean by dates "clashing"? Do you mean that two periods of time overlap? If so, try:

if ($html_start<=$db_end && $html_end>=$db_start) {

And I would convert the dates to UNIX timestamp format (using strtotime) before doing the comparison as it'll be more reliable (comparing 'YYYY-MM-DD' against 'YYYY-MM-DD' will do a text comparison, which will cause a problem if you are comparing '2006-6-10' against '2006-10-10').