cancel
Showing results for 
Search instead for 
Did you mean: 

Start Date and End Date of Current and Previous Fiscal Years

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

joseph_reddy88
Participant
0 Kudos

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