Hello,
I am working with creating a dynamic filter from a graphic view in SAP Datasphere for a data extraction from a remote table that contains 20 million records from the source system. I would like to apply a date filter to only extract into Datasphere the previous two years plus current to omit from extracting in the 20 million records.
Currently I have a manual date filter of POST_DATE BETWEEN '20230101' AND '99991231'. I would like to apply a dynamic filter so I won't have to change the dates manually each year. I also need the date function of the filter to start on the first day of the previous two years.
I tried subtracting the 2 years from the current date function but then the filter will start two years back based on current date. Example: 20230212. I need the date to be 20230101
Then for when the year switches to 2026 then the date range of the dynamic filter will be '20240101' AND '99991231'
If anyone can provide assistance that would be great.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.