Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Fiscal year

how to create fiscal year from given date

5 Replies
Not applicable

Re: Fiscal year

Re: Fiscal year

Hi,

Use YearName(DateField,0,4)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
arulsettu
Honored Contributor III

Re: Fiscal year

LOAD *,

Day(date) as day,

Month(date) as month,

Year(date) as year,

yearname(date,0,4)as FinancialYear;

sasikanth
Valued Contributor III

Re: Fiscal year

hi

Try some thing like this

=Year(date('date field','DD/MM/YYYY))

venkatasreekant
Valued Contributor

Re: Fiscal year

Try this:

[Requesterdate] means your date field in the Data ..

right(year(addmonths([Requester Date],-3)),2) & '-' & right(year(addmonths([Requester Date],-3))+1,2)