...
Formula:
Code Block | ||
---|---|---|
| ||
(function(){ var startDateCustomFieldId = 10101;//Date picker - Start Date var testDaysCustomFieldId = 10200;//Number field - Test Length in Days if(cfValues[startDateCustomFieldId] != null){ return cfValues[startDateCustomFieldId].time + cfValues.getOrDefault(testDaysCustomFieldId, 0)*24*60*60*1000 } })() |
Prepare value for view:
Code Block | ||
---|---|---|
| ||
if(formulaValue != null){ "" + formulaValue.date + "/" + (formulaValue.month+1) + "/" + (formulaValue.year-100) } |
...
Formula:
Code Block | ||
---|---|---|
| ||
(function(){ var endDateCustomFieldId = 10011;//Formula date field - End Date var agingCustomFieldId = 10202;//Number field - Aging Length in Days if(cfValues[endDateCustomFieldId] != null){ return cfValues[endDateCustomFieldId].time + cfValues.getOrDefault(agingCustomFieldId, 0)*24*60*60*1000 } })() |
Prepare value for view:
Code Block | ||
---|---|---|
| ||
if(formulaValue != null){ "" + formulaValue.date + "/" + (formulaValue.month+1) + "/" + (formulaValue.year-100) } |
...
Formula:
Code Block | ||
---|---|---|
| ||
(function(){ var startDateCustomFieldId = 10101;//Date picker - Start Date var testDaysCustomFieldId = 10200;//Number field - Test Length in Days return calculate() function calculate(){ var now = new Date() var start = cfValues[startDateCustomFieldId] var testingDays = cfValues[testDaysCustomFieldId] if(start == null || start.getTime() > now.getTime() || testingDays == null || testingDays == 0){ return 0 } else { return Math.min(100, Math.round(dayBetweenDates(start, now)/testingDays*100)) } } function dayBetweenDates(date1, date2){ return (date2.getTime() - date1.getTime())/ (1000 * 3600 * 24) } })() |
View:
Code Block | ||
---|---|---|
| ||
$formulaValue% |
...
Formula:
Code Block | ||
---|---|---|
| ||
(function(){ var endDateCustomFieldId = 10011;//Formula date field - End Date var agingCustomFieldId = 10202;//Number field - Aging Length in Days return calculate() function calculate(){ var now = new Date() var end = cfValues[endDateCustomFieldId] var agingDays = cfValues[agingCustomFieldId] if(end == null || end.getTime() > now.getTime() || agingDays == null || agingDays == 0){ return 0 } else { return Math.min(100, Math.round(dayBetweenDates(end, now)/agingDays*100)) } } function dayBetweenDates(date1, date2){ return (date2.getTime() - date1.getTime())/ (1000 * 3600 * 24) } })() |
View:
Code Block | ||
---|---|---|
| ||
$formulaValue% |
...