most recent quarter end date

[kmstephenson]

Hi All,

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.

Thanks!

Tina

[mdmukramali]

Hi,

Can you try something like this

=If(QuarterEnd(EndDt)=EndDt,EndDt,

          QuarterEnd(Date(QuarterStart(EndDt)-1,'YYYY-MM-DD')))

[YoussefBelloum · Accepted solution]

Hi,

Try this:

QuarterEnd(QuarterStart(EndDt )-1)

[maxgro]

LOAD

     EndDt,

     Date(Floor(

          IF(Date(EndDt, 'YYYY-MM-DD')=Floor(QuarterEnd(Date(EndDt, 'YYYY-MM-DD'))),

               EndDt,

               QuarterEnd(Date(EndDt, 'YYYY-MM-DD'), -1)

     ) ), 'YYYY-MM-DD') as Q2EndDt

;

load * inline [

EndDt

2017-07-31

2015-09-30

];