varun asked 10 years ago
using custom format:
$f = array();
$f["column"] = "DueDate";
$f["op"] = "??";
$f["value"] = "2013-11-25";
$f["css"] = "'background-color':'Bisque'";
$f_conditions[] = $f;
this is not executing for some reason!! and if i remove op and value,its running.
what can i do to check DueDate less than(invalid character so given ??) current Date.i mean how do i specify date in this above code and whats wrong here?why am i not getting result,
Abu Ghufran answered 10 years ago
Hello,
This is because the comparison is being done on Javascript level and it does not understand the YYYY-MM-DD convention.
Alternate is to format the duedate as date_format(duedate,'%Y%m%d') as duedate_custom … .and apply this formatting afterwards.
You can check demos/appearence/conditional-format.php sample, it contains conditional date formatting.
