...
Code Block | ||
---|---|---|
| ||
var startDateCustomFieldId = 10101;//Date picker - Start Date var testDaysCustomFieldId = 10200;//Number field - Test Length in Days var now = new Date() var start = cfValues[startDateCustomFieldId] if(start != null){ if(start.getTime() > now.getTime() ){ 0 } else { Math.min(100, Math.ceilround(dayBetweenDates(start, now)/cfValues[testDaysCustomFieldId]*100)) } } function dayBetweenDates(date1, date2){ return (date2.getTime() - date1.getTime())/ (1000 * 3600 * 24) } |
...
Code Block | ||
---|---|---|
| ||
var endDateCustomFieldId = 10011;//Formula date field - End Date var agingCustomFieldId = 10202;//Number field - Aging Length in Days var now = new Date() var end = cfValues[endDateCustomFieldId] if(end != null){ if(end.getTime() > now.getTime() ){ 0 } else { Math.min(100, Math.ceilround(dayBetweenDates(end, now)/cfValues[agingCustomFieldId]*100)) } } function dayBetweenDates(date1, date2){ return (date2.getTime() - date1.getTime())/ (1000 * 3600 * 24) } |
...