Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
May be something like this this:
=If(Len(Trim(Year(DateField))) > 0, 'FY-'& Year(DateField))
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.