8 Replies Latest reply: Nov 4, 2014 4:20 AM by Sebastian Schuler RSS

    Transform Date to Number while keeping the value

    Sebastian Schuler

      Hey community

       

      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?

       

      regards

      Sebastian