Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil2288
Creator III
Creator III

How to create Financial year from Normal date period

HI all

I have a query that how i can create Financial year that is Apr to Mar from normal date period.

Comments appreciated

Thanks and Regards

Sunil

1 Solution

Accepted Solutions
Not applicable

Dear Sunil,

You canget financial year by using function called 'Yearname"

ex: yearname(Date_Field,0,4)

It will treat Apr as the first month in finanacial Year.Check and let me know.

Thanks & Regards

Jai

View solution in original post

2 Replies
Not applicable

Dear Sunil,

You canget financial year by using function called 'Yearname"

ex: yearname(Date_Field,0,4)

It will treat Apr as the first month in finanacial Year.Check and let me know.

Thanks & Regards

Jai

sunil2288
Creator III
Creator III
Author

Hi Ij,

Thanks Ij... It Works...

Regards

Sunil