This content has been marked as final. Show 8 replies
I am having the following issue:
I would like to reload data from a table within SAP. Since I only need the latest 3 months I applied this formula:
date(AddMonths(MonthStart(today()),-2),'YYYYMMDD') which would result by today in 20140801.
The problem is, if I put that into the where statement, it wouldn't work. If i put the plain numbers - hard coded - into it, it works. I think the solution would be, to transform the date format shown above, into a number. Unfortunatley, if I do that, it turns to 41852.
How would you guys go about such an issue?