Calibration DaysLeft

PHOTO EMBED

Tue Jan 07 2025 14:54:43 GMT+0000 (Coordinated Universal Time)

Saved by @Pooja

for each  rec in Calibration_Master[ID != null && Cal_Due_Date != null]
{
	if(rec.Today != zoho.currentdate)
	{
		rec.Today=zoho.currentdate;
		//info rec.Today;
		info rec.Cal_Due_Date;
		daysleft = daysBetween(rec.Today,rec.Cal_Due_Date);
		rec.Days_Left=daysleft;
		info daysleft;
		if(rec.Days_Left.toNumber() <= 30 && rec.Days_Left.toNumber() > 0)
		{
			rec.Status1="Attention";
		}
		else if(rec.Days_Left.toNumber() > 30)
		{
			rec.Status1="No Issue";
		}
		else if(rec.Days_Left.toNumber() <= 0)
		{
			rec.Status1="Urgent";
		}
	}
}
content_copyCOPY