Please check the Optimized SQL and see if your where condition is reflected in the Display optimized SQL screen.If not reflected, check if you can update your data flow, to get the where condition displayed in the optimized SQL screen .Also ,try not ...
I suppose you are trying to convert date to char using to_char function. AAAA is not the right format, Use YYYY instead of AAAAEx: to_char( sysdate(),'YYYYMMDD')https://help.sap.com/viewer/dab65b1584e04026a132a06a711e3f5a/Cloud/en-US/57602a1c6d6d1014...
1) you can create a custom function to extract the year, months,days from the string2) Then subtract the days first from the system date, then use add_month function to remove the months and yearfrom your example : add_months( (sysdate()-17), (-1*11...
