getting start and end date of fiscal year

[swiftfahad]

HI All

I have a dimension of fiscal year in qlikview app  shown in selection box of my app

starting from 2000-2001 to 2022-2023....... my fiscal periods say (2000-2001) is 01-Jul -2000 to 30-Jun-2001

now I want to create a variable  that shows the start date and another variable shows the end data of fiscal year that i select in selection box.

e.g  when i select 2005-2006 in selection box

V_Startfyear= 01-jul-2005

V_Endfyear= 30-jun-2006

plz advice

[tresesco]

YearStart(DateField, 0, 7)

YearEnd(DateField, 0, 7)

[swiftfahad]

I don't have date field I only have fiscal year field.

[vinieme12]

you can use the same solution suggested by @tresesco  and replace datefield with makedate()

yearstart(makedate(Yearfield,1,1),0,7)

yearend(makedate(Yearfield,1,1),0,7)