How to display fiscal year

[#1]

hi

i have a query fiscal year(2013Q1) this formate,

i want to change fiscal year(FY13) this formate

plz help me,

Thanks,

[peschu123]

Hi damodark,

please post some more details or sample data. It's not clear to me what you're going to do.

One shot in the dark... Take a look at mapping tables or perhaps this thread about master calender maybe helpful.

[er_mohit]

try this

'FY' & Right( Year(TempDate),2) as YearQtr

here TempDate is my fieldname

[#4]

Hi ,

     You can try the below code.

='FY'& Date( Date#( Left( '2013Q1',4),'YYYY') ,'YY')

Please let me know if there is anything.

//yusuf

[jagan]

Hi,

Try like this

='FY'&Mid('2013Q1', 3, 2)

Hope this helps you.

Regards,

Jagan.