Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Financial year format -2011/12 etc.

I am using the following piece of code to calculate financial year

calendar.bmp

For example. This displays 2011 for any date between April 2011 and April 2012

However I would like the date to display: 2010/11,  2011/12, 2012/13 etc

I would appricate any help anyone has with this

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

  you can use with Yearname(TempDate,0,4) as Fin_Yr.

It will give you the date field as 2011-2012,2010-2011..etc

-Jai

View solution in original post

1 Reply
Not applicable
Author

Hi,

  you can use with Yearname(TempDate,0,4) as Fin_Yr.

It will give you the date field as 2011-2012,2010-2011..etc

-Jai