topic Is there Half Year End Date function in Qlikview? in QlikView https://community.qlik.com/t5/QlikView/Is-there-Half-Year-End-Date-function-in-Qlikview/m-p/849979#M1008392 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I used the following Date functions in Qlikview:</P><P>YearEnd( date [, shift = 0 [, first_month_of_year = 1]] )</P><P>QuarterEnd( date [, shift = 0 [, first_month_of_year = 1]] )</P><P>MonthEnd( date [, shift = 0] )</P><P></P><P>Do you know if there's something like that for Half Year end? Can you please advise a workaround for this?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 13 May 2015 10:10:02 GMT 2015-05-13T10:10:02Z Is there Half Year End Date function in Qlikview? https://community.qlik.com/t5/QlikView/Is-there-Half-Year-End-Date-function-in-Qlikview/m-p/849979#M1008392 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I used the following Date functions in Qlikview:</P><P>YearEnd( date [, shift = 0 [, first_month_of_year = 1]] )</P><P>QuarterEnd( date [, shift = 0 [, first_month_of_year = 1]] )</P><P>MonthEnd( date [, shift = 0] )</P><P></P><P>Do you know if there's something like that for Half Year end? Can you please advise a workaround for this?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 13 May 2015 10:10:02 GMT https://community.qlik.com/t5/QlikView/Is-there-Half-Year-End-Date-function-in-Qlikview/m-p/849979#M1008392 2015-05-13T10:10:02Z Re: Is there Half Year End Date function in Qlikview? https://community.qlik.com/t5/QlikView/Is-there-Half-Year-End-Date-function-in-Qlikview/m-p/849980#M1008393 <HTML><HEAD></HEAD><BODY><P>if (Month(date) &lt; 7, QuarterEnd(MakeDate(1, 6, Year(date))), YearEnd(date))</P></BODY></HTML> Wed, 13 May 2015 10:15:27 GMT https://community.qlik.com/t5/QlikView/Is-there-Half-Year-End-Date-function-in-Qlikview/m-p/849980#M1008393 Peter_Cammaert 2015-05-13T10:15:27Z