Skip to Content
0
Apr 15, 2010 at 02:29 PM

Condition on Date difference.

33 Views

Hi Experts,

We have a requirenment where in we need to dispaly only those records where the Due date < Current date.

Due date is a characteristic so I have used formula Variable of repacement path type to convert it into a KF and fetching the Current date through a customer exit.

Then I have a CKF = Current Date - Due Date.

And I have used condition CKF Greater than 0.

I am not able to get any data except for the result row when I execute the query.

And I tried to display current date, Due date and there difference separately in the report to check if the data is correct or not

and I am getting correct dates and difference too. but when the condition is activated I am not able to see any records except for the result row.

Any inputs on this will be highly appreciated.

Thanks

Shubh Karan