Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member185165
Active Participant

Hi All,

I had a requirement to find the date difference from the field LETZTZUG of table s032 and the current date.

Here the problem was getting the current date. I got the current date using now() function in calculated column functions.

The output of the now() was in yyyy-mm-dd hrs and second. I used date(now()) and got it as yyyy-mm-dd.

With this I was still not able to use daysbetween in order to find the duedate betwen LETZTZUG  and currentdate.

Then I used replace() function to eliminate '-' from the yyyy-mm-dd. So after that I could calculate the daysbetween().

This will overcome the problem of not having to_dats in calculated column.

And we have the netdue date here.

I hope this will be helpful for others. Experts please provide your suggestions on this.

Thanks & Regards,

Vijay

3 Comments
Labels in this area