Is there Half Year End Date function in Qlikview?

[#1]

Hello,

I used the following Date functions in Qlikview:

YearEnd( date [, shift = 0 [, first_month_of_year = 1]] )

QuarterEnd( date [, shift = 0 [, first_month_of_year = 1]] )

MonthEnd( date [, shift = 0] )

Do you know if there's something like that for Half Year end? Can you please advise a workaround for this?

Thanks!

[Peter_Cammaert · Accepted solution]

if (Month(date) < 7, QuarterEnd(MakeDate(1, 6, Year(date))), YearEnd(date))