Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Check this expression.
=Date(YearStart(Today(),0, 4), 'DD-MMM-YYYY')
Regards,
Jagan.
Hi
I think current financial year is 2011 then this should be (no need +1)
LET CURRENT_YEAR = YEAR(YEARSTART(NUM(TODAY()),0,4));
Check with this
=Date(AddMonths(YearStart(MakeDate(CURRENT_YEAR,CURRENT_MONTH),0,4),1+CURRENT_MONTH), 'DD-MMM-YYYY')