Year converstion

[Srinivas]

Hi all,

I have one question, i have one date filed we need to convert to FY-Year like below way:

above FY list box i have converted based on : ='FY'&- Year(YearName(Year, 1, 7)) , but my question is FY came extra, i no need this one

how to remove this one.

Regards

Munna

[sunny_talwar]

May be something like this this:

=If(Len(Trim(Year(DateField))) > 0, 'FY-'& Year(DateField))

[jagan · Accepted solution]

Hi Srinivas,

I think there are some null values in your Year field, check for that rows, or try below script

LOAD

*,

If(Len(Trim(Year)) > 0, 'FY'&- Year(YearName(Year, 1, 7)))

FROM DataSource;

Regards,

jagan.