2 Replies Latest reply: Mar 29, 2012 8:02 AM by Celambarasan Adhimulam RSS

    Need Help in variable..

      Hello All,

       

      In my applications year is displaying 2010,2011,2012 only.My financial year-end is March-2012.

      In my applications they taken year=2012. now i created variable

      LET CURRENT_YEAR = (YEAR(YEARSTART(NUM(TODAY()),0,4))+1);

      LET CURRENT_MONTH = IF(NUM(MONTH(NUM(TODAY())))>3,NUM(MONTH(NUM(TODAY())))-3,NUM(MONTH(NUM(TODAY())))+9);

      it is showing year=2012 and month=12 now it is correct,but what happen for next month(i.e.,after financial year-end).this will work.

      can any one give some idea for creating variable,i.e.,it will displays in text box in my final appilication like date-month-year is 01-Apr-2012.