how to write expression

[kunkumnaveen]

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

[#2]

Hi,

try this,

'FY'&Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY') &'-'&Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year

-Joyson G

[tamilarasu · Accepted solution]

Try this,

'FY'& Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY')  &'-'& Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year

[susovan]

Hi Naveen,

It might be work.

Please check this attachment.