I would like to see Round, RoundUp, and RoundDown functions available in the operators in Bionic Rules Formula Fields, and also be able to apply these functions to numeric results of calculations with dates. I have a system wherein contracts are listed as multiple contiguous years, i.e.
Start Date: August 1 2012
End Date: August 1, 2018
I need to know the most recent anniversary of the account in order to know how far along they should be in an annual client lifecycle and trigger events based on that timeframe. This is far preferable to adding an OR function for every possible year increment up to our contract max length (up to 20 years). In this example the correct result of a function to calculate the most recent anniversary is August 1, 2017. The best way that I have come up with to get the correct result involves rounding down: