Are you working with transaction dates? If your fiscal year does not mirror the calendar year, GridView knows about your Fiscal Calendar.
Check out the help text for
DATESTART(),
DATEEND(),
DATEIN() and
INCLUDEAMOUNT() functions.
To get the (4 digit) year of the current fiscal period use:
DATESTRING(DATESTART("M","F"),"%Y")
where "M" is the current period (month) and "F" tells GridView to use the fiscal calendar. The DATESTRING() function returns just the 4 digit year. To return the 2 digit year, substitute "%y" for "%Y".
Previous Topic
Index
