Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i need to create yearname field like 2014-2015,2013-2014 etc
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.
=Year(Today()) & '-' & (Year(Today())+1)
Change Today() with your DateField
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.