2 Replies Latest reply: Jul 1, 2013 2:11 AM by Tushar Suvarna RSS

    Generating a inline table with last date of each month of a year

    Tushar Suvarna

      Hi,

       

      I want to generate an inline table using qv script such that  the table contains     field  Year ,  Month, LastDayMonth,

       

      here is an example

       

      YearMonthLastDayMonth
      2012 Jan31-01-2012
      2012Feb29-02-2012
      2012Mar31-03-2012
      2012Apr30-03-2012
      2012May31-03-2012
      2012Jun30-03-2012
      2012Jul31-03-2012
      2012Aug30-03-2012
      2012Sep31-03-2012
      2012Oct30-03-2012
      2012Nov31-03-2012
      2012Dec31-03-2012

       

       

      Year can be from 2000 till 2020

      can anyone help me out with this.:)

       

      Regards,

       

      Tushar