Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you try something like this
=If(QuarterEnd(EndDt)=EndDt,EndDt,
QuarterEnd(Date(QuarterStart(EndDt)-1,'YYYY-MM-DD')))
Hi,
Try this:
QuarterEnd(QuarterStart(EndDt )-1)
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
];