Preview:
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";
	}
}
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