RKF date picking some garbage value

[former_member202517]

Hi All,

We have situation as per below.

We have

Finish date- start date= variance.

Both Finish and start date are RKF with combination of 1 field different. The only difference is Event type is 1 for Start date

with this combination the start date is 01.10.2014

We dont have combination of the above for Finish date and system is picking the max date for the finished date and difference is showing as 560,415 days.

Can we write any condition if we the above combination is not available the system should consider as 00.00.0000.

Appreciate your thoughts.

Thanks,

Ravi.

[former_member220624]

Hi Ravi,

Do you have field present in the underlying flow which identifies that a record has finish date as filled/blank ?

If yes,you can use it in the RKF and put a restriction as not blank.

If no,you can think of creating a custom info-object and then populate this in the underlying data provider based on finish date (probably a flag as 'X') Then you can use this field in RKF to eliminate finish date blank values.

Hope this helps.

Regards,

Amit

[former_member202517]

Hi Amit,

There is no field which identifies the record is blank/filled.

[former_member220624]

Hi Ravi,

Then you can go ahead by including a custom info-object in your underlying dataprovider and flag it as per your requirement.

Then use this in your RKF.

Regards,

Amit