Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
this is my expression to get financial year ,which is working great
'FY'&year(AddYears(yearstart (ENSTEHDAT, 1, 4),-1)) &'-'&Year(yearstart (ENSTEHDAT, 1, 4)) as Year
this is what i am getting
ESTEHDAT Year
10/29/2003 FY2003-2004
what i am looking is this
ESTEHDAT Year
10/29/2003 FY03-04
how to get only two values from year fiels
Try this,
'FY'& Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY') &'-'& Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year
Hi,
try this,
'FY'&Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY') &'-'&Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year
-Joyson G
Try this,
'FY'& Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY') &'-'& Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year
Hi Naveen,
It might be work.
Please check this attachment.