I want to extract previous quarter from date

[siddharthsoam]

Hi ,

I want to fetch the previous quarter exit date whenever I select a recent quarter date. For example if I select a date 31-Aug-2017 it should return 30-Jun-2017. if I select 31-May-2017 it should return 31-Mar-2016

[shraddha_g]

Date(Monthend(Addmonths(Max(DateField),-3)),'DD-MMM-YYYY')

[shraddha_g]

Date(Addmonths(QuarterEnd(Max(DateField)),-3),'DD-MMM-YYYY')

[sunny_talwar · Accepted solution]

Or this

Date(Floor(MonthEnd(Max(Date), -3)))

MonthEnd(Max(Date), -3) should take your 3 months back

Floor() should make a timestamp back to a date

Date() can be used for formatting