I have a request to calculate a rolling 12 month period when given a date. I know I can use the AddYears function to easily add a year to any date, but part of the requirement is that the period end must always be the last day of the prior month.
For example if I'm giving a date of 1/14/2018 my result should NOT be 1/14/2019, it should be 12/31/2018. Has anyone had to deal with this before, and is there a simple solution that I'm overlooking?
Thanks,
Josh
#Handlers------------------------------
Josh Herron
------------------------------