Ageing calculation

[Phani_1982]

how to calculate ageing in days if start date of defect is 1st of April and end date is today if the defect is not repeating in any of the day then defect should not continue and if defect starts again after a day or two then defect should be calculated from the next start date

[caltang · Accepted solution]

DateTimeDiff with DateTimeNow against your Start Date.

Put a condition to your Start Date based on the defect's period (as defined by you / end user).