Last Date in Quarter help

[#1]

Hi All,

I am trying to get the last date in the quarter. How do I convert the following pseudo code to Qlikview?

Function LastDateInQuarter([Year] number, [Quarter] number) As Date

TrueYear = Year + 2000
LastDateInQuarter = LAST_DAY(TO_DATE(Quarter*3||"-01-"||TrueYear,'mm-dd-yyyy'))

End Function LastDateInQuarter

Any suggestions?

Thank you.

[MarcoWedel]

you could use something like

Date(Floor(QuarterEnd(any Timestamp in this quarter)))

regards

Marco

[MK_QSL · Accepted solution]

Load

     Date,

     QuarterEnd(Date) as QTREND

Inline

[

  Date

  01/01/2014

  05/01/2014

  10/02/2014

  15/03/2014

  27/04/2014

];