Difference Between Two Dates

  
  
// This is all being displayed on a list grid, btw.  
  
/* Label of type "Date" set from datepicker on maint page..everything set correctly, using datetime  
   format of MySQL.  
*/  
  
$date1 = $Component->date_entered1->GetValue();   
  
if($date1 == NULL)  
 $Component->text_label1->SetValue("date1 is NULL");  
  

  
/* Note: This function is busted, somewhat, in that it doesn't take leap years into account,  
   and every month is considered to have 30 days, etc. PHP version 5.3 fixes all this, with  
   "num of days different" being an added member function to the Date class.  
   In other words, this is test code to see if things are working correctly.  
*/  
  
// This code is run via "Before Show" event.  
  
Function DateDiff($today, $compare_date)  
{   
  
 $tod = strtotime($today);  // Can use strtotime("now") here, of course, but picking it up from textbox/datepicker..  
 $test_date = strtotime($compare_date);  
 $diff = $tod - $test_date;  
  
 $years = floor($diff / (365*60*60*24));  
 $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));  
 $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));  
  
 return($days);  
  
}  
  
Function OneDayCheck($date_diff)  
{  
 if($date_diff == 1)  
  return("day");  
 else  
  return("days");  
}  
// Yeah, I know. What if there are zero days different :D. This is test code :p  
  
$db = new clsDBConnection1();  
  
$todays_date = CCDLookUp("todays_date","HSE","hse_id=" . $Container->hse_id->GetValue(), $db);  
$record_only = CCDLookUp("record_only","HSE","hse_id=" . $Container->hse_id->GetValue(), $db);  
$days_diff = DateDiff($todays_date, $record_only);  
$num_days_diff = OneDayCheck($days_diff);  
$Container->record_only_text->SetValue("(" . $days_diff . " " . $num_days_diff . ")");  
  
$first_aid = CCDLookUp("first_aid","HSE","hse_id=" . $Container->hse_id->GetValue(), $db);  
$days_diff = DateDiff($todays_date, $first_aid);  
$num_days_diff = OneDayCheck($days_diff);  
$Container->first_aid_text->SetValue("(" . $days_diff . " " . $num_days_diff . ")");  
  
$db->close();  
  
/*  
   There is going to be a ton of dates for comparison in the record, so I'll eventually roll it up into  
   on big SQL statement that reads them all in a single shot, rather than calling CCDLookUp() over  
   and over. WAY too many queries and much slower.  
*/  
  

Quote :

Well, there may never actually be a situation where $date == NULL. If
you're letting CodeCharge format your date by specifying the field as a
date field, then it builds the field value into an array. That's what
the post is referring to, array values (date[0], etc.). The value may
actually look something like '0000-00-00 00:00:00'.

  
  
$date = $Component->todays_date->GetValue();  
  
if($date[0] == NULL)  
  $Component->text_label->SetValue("Yep...it is NULL");  
else  
  $Component->text_label->SetValue("Non-NULL Value");    
  

Quote :

I go back to what I preach constantly - debug using echo. Echo to the
screen in the field's OnValidate event the value.

echo "The Date: " . $Component->GetValue(); exit;

There's even an action 'Print Text' that also does this. Use it, love
it, be happy.

Quote :

Also, since you're able to set the value of the field to "date1 is
NULL", that tells me that you don't really have the field defined as
date, but rather as text. If it were set to date, then it should throw
a type-mismatch error when CodeCharge attempts to parse 'date1 is NULL'
into a date format.

Quote :

Finally, checking for 'NULL' will be different with various databases
and scripting languages. Just check for:

if (!$Component->GetValue())