Up to Blueriq 15.12, the YEARS BETWEEN function sometimes incorrectly calculated the number of years between two date values, if a leap day is involved:
We corrected this behavior in Blueriq 15.12.
| Date 1 | Date 2 | YEARS BETWEEN up to 15.11.1 | YEARS BETWEEN from 15.12 |
|---|---|---|---|
| 2016-02-29 | 2020-02-28 | 4 | 3 |
| 2016-02-29 | 2020-02-29 | 4 | 4 |
| 2020-02-29 | 2021-02-28 | 1 | 1 |
| 2019-02-28 | 2020-02-28 | 1 | 1 |
| 2019-02-28 | 2020-02-29 | 1 | 1 |
This change could impact your calculations in certain specific cases. Please review the impact for your project when upgrading to Blueriq 15.12.
If no leap day is involved, the behavior of YEARS BETWEEN will remain the same when upgrading to Blueriq 15.12.
Overview
Content Tools