Start Date and End Date of Current and Previous Fiscal Years

[Former Member]

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

[joseph_reddy88]

Hi Satish,

Can i know how you are loading data into HANA DB.What is your source?  Are you using SLT Based replication.If It is SLT i think you can apply dynamic filter using SQL in SLT Advanced settings.

Thanks,

Joseph