Duration in Months (durnmnths) : Knowledge Base

Duration in Months (durnmnths) Print

Modified on: Tue, 28 Jul, 2020 at 3:45 PM

The duration of an item represented as months.

Note: A month in this case is represented as 30.4 days (365/12).

Type of Data Returned

Will return the number of months the item has for duration.

Examples

Increasing the value of the duration by a month

durnmnths + 31

Determining if an item is deemed “long” or “short” based upon its duration in months.

IF(durnmnths>12, “Long”, “Short”)

Did you find it helpful? Yes No

Help Desk Software by Freshdesk