5 Replies Latest reply: Sep 8, 2014 6:38 AM by Mathew Thomas RSS

    For a month and year selected how do I select the last day?

      Hi everyone,

       

      In an  expression I would like to use the date of the last day of the month and year that I have selected eg would like 31st May 2014 in date format  as predetermined by QlikView script if I select May in its listbox and 2014 in its listbox or 31st August 2011 if I pick August and 2011 etc.

       

       

      Help would be appreciated