Trying to make cell color RED if AGE is = or < 18 using a function
I'm trying to create a function where if the age of the user is less than or equal to 18 ( legally a minor ) the cell back ground color would turn RED.
I've been trying to work this out but I'm not sure how to approach.
With this current function setup I am getting the following error, and I havn't even got to the changing the cellcolor portion yet :(
The Left expression is of type TIMESTAMP and the right expression is of type BIGINT And the operator - is not valid here
- bool isMinor(int Student_DOB)
{
Minor = false;
if ((((zoho.currentdate - Student_DOB) / (1000 * 3600 * 24 * 365))).toLong() > 19)
{
Minor = true;
if ((((zoho.currentdate - Student_DOB) / (1000 * 3600 * 24 * 365))).toLong() <= 19 )
{
Minor = false;
}
}
return Minor;
}
would someone care to help? I'm lost :(