for each rec in Calibration_Master[ID != null]
{
calhist = Calibration_History[Calibration_Master_ID == rec.ID];
if(calhist.Cal_Due_Date < zoho.currentdate && calhist.Status != "Completed")
{
calhist.Status="Overdue";
}
if(calhist.Cal_Due_Date >= zoho.currentdate && calhist.Status != "Completed")
{
calhist.Status="Due";
}
if(rec.Cal_Due_Date < zoho.currentdate)
{
rec.Status="Overdue";
}
if(rec.Cal_Due_Date >= zoho.currentdate)
{
rec.Status="Due";
}
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter