Date progression over many years
Posted on 2014-09-23
Experts, I hope I can explain this well. How would you suggest to extend a date, for example, the end of each quarter for the next 15 years? I don't know if a function would be how to do this or if it's rather simple.
Let's say the end of the next qtr is 9/31/2014. Show the next end Of qtr dates to a date 15 years into the future ([FacilityEndDate]. I need to display each of these dates. I also need to apply this same logic to dates that are at the end of a month, semiannually and yearly as well.