Schedule a function that exceeds number of statement execution limit
Hi guys,
I've got an error on a schedule that I'm running to update the age of my service users. It says the number of statement execution limit is exceeded. Each day I use a schedule to run the following function:
void update_age()
{
for each rec in Service_users
{
if(rec.Date_of_birth != null)
{
rec.Age=(((zoho.currentdate - rec.Date_of_birth)) / (1000 * 3600 * 24 * 365)).toLong();
}
}
}
Is there some other way I should do this?
Thanks in advance for any advice. I might just not be thinking this through properly.