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