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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |