Skip to Content
0
Former Member
Aug 17, 2016 at 12:43 AM

Start Date and End Date of Current and Previous Fiscal Years

215 Views

Hi

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.

Data:

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?

Thanks

Satish