Forum Discussion
Solved
Date Calculation between three dates
My data set has a creation date, reopend date, and closed date column. Not all lines have a reopen date. I am trying to create a column that will calculate the age based on the reopend date if it has...
This formula did not quite work but it was a great help to start testing. I was able to get the code to work with the following:
Age =
IF(
[Reopen] <> BLANK (),
[Closed date]-[Reopen date],
[Closed date]-[created date])
hi Truecharv
In addition to the measure proposed by Nathaniel, you may also create a column like this:
Age =
IF(
[reopen date] <> BLANK(),
DATEDIFF([closed date], [creation date]), DAY),
DATEDIFF([reopen date], [creation date], DAY)
)the result is in days, you may change DAY to other unit if necessary, like YEAR.
This formula did not quite work but it was a great help to start testing. I was able to get the code to work with the following:
Age =
IF(
[Reopen] <> BLANK (),
[Closed date]-[Reopen date],
[Closed date]-[created date])