That was the context of the question. How ever I got a different question now. I need to display the default year such that if the
current date falls under 01-April-(year) to 31-March-(year+1), the default financial year has to be displayed as (year+1).
Can you help me in developing expression that displays the value of the year accordingly.
Use the InYearToDate() function as in this example:
=InYearToDate('01/04/2012', '31/03/2012', 0, 4)
Where the first parameter is the date, the second the end of the year, the third (0) shows this year, next year (1), previous year (-1), and the fourth (4) in which natural month the year starts (April in this case). The example above will return 0 (false) because is not on this fiscal year, but
=InYearToDate('01/01/2012', '31/03/2012', 0, 4)
will return -1 (true) because it's on this fiscal year
Hope that helps.