Hi All,
I currently have a calc cell which will be used to determine the colour of the cell. I have the colour coding of the cell working as I have used it before and I can get it to work in this case.
My issue is when I use the following formula
It always returns green. It seems to not like the $element variable and includes colour_code (the element name) before the output.
Any ideas?
I currently have a calc cell which will be used to determine the colour of the cell. I have the colour coding of the cell working as I have used it before and I can get it to work in this case.
My issue is when I use the following formula
Code:
$element = '{data_ponds___next_volume_check}';
$olddate = strtotime("$element");
$new = date('d-m-Y');
$newdate = strtotime("$new");
if ($olddate > $newdate) {return "green";}
elseif ($olddate < $newdate) {return "red";}
elseif ($olddate == $newdate) {return "orange";}
It always returns green. It seems to not like the $element variable and includes colour_code (the element name) before the output.
Any ideas?