...
As of 6.4.0, there is no out of the box directive for this, so the set-column directive must be used to calculate the year difference. This can be done as:
set-column :year_diff dt1.getYear() - dt2.getYear()
where year_diff is the name of a new column, and the dt1 and dt2 columns are the names of the timestamps that are being subtracted.
...
As of 6.4.0, there is no out of the box directive for this, so the set-column directive must be used to calculate the month difference. This can be done as:
set-column :month_diff 12 * (dt1.getYear() - dt2.getYear()) - (dt1.getMonthValue() - dt2.getMonthValue())
where month_diff is the name of a new column, and the dt1 and dt2 columns are the names of the timestamps that are being subtracted.
...
As of 6.4.0, there is no out of the box directive for this, so the set-column directive must be used. This can be done as:
set-column :day_diff date:DAYS_BETWEEN(dt1, dt2)
| Page Properties | ||
|---|---|---|
| ||
|