I have a scenario where we need to load data for current fiscal year and previous fiscal year.
I'm not building any views in HANA.
I'm just trying to load the data in sql hana.
Current Fiscal Year Start Date : 10/1/2015
Current Fiscal Year End Date : 9/30/2016
Previous Fiscal Year Start Date : 10/1/2014
Previous Fiscal Year End Date : 9/30/2015
I would like to get this data filters in SELECT statement.
I do not want to hard code this as Year=2016 or 2015.
Request to help if there is any date functions which will achieve this?