how to create yearname

[#1]

hi,

i need to create yearname field like 2014-2015,2013-2014 etc

[MK_QSL]

=Year(Today()) & '-' & (Year(Today())+1)

Change Today() with your DateField

[tresB · Accepted solution]

Probably you are trying to get fiscal year. If so try like:

Load

          YearName(DateField, 0, 4) as yearName    // 4- denotes first month of fiscal year.