This content has been marked as final. Show 3 replies
I have an EndDt field in format YYYY-MM-DD. I would like to return the value of the most recent quarter end date.
For example, if my EndDt is 2017-07-31, I would like to return 2017-06-31 (Q2 EndDt). If my EndDt is 2015-09-30, this falls on a quarter end date so this would return the same value - 2015-09-30.