Hi Qlik Engineers,
I have a requirement to create a date variable for Fiscal year end date which always returns last day of fiscal year as our fiscal year starts from 4/1/20 so last day is (3/31/20) and should change next fiscal year dynamically. We use this variable while loading data for one of my script . Can someone please let me know how to create one?
before we were using standard calendar variable like below:
Let vEOYDate = date(num(firstworkdate(yearstart(firstworkdate(today(), 2), 0), 2)),'MM/DD/YYYY')
The above variable always returns Last day of previous Calendar year like 12/31/2019
but requirement got changed and request is to use fiscal year end date in the script instead calendar year. Can some one help what needs to be changed in the above variable to get Fiscal year end date?
Any help will be really appreciated.
Regards,
