Filtering records on basis of date fields in listpart

(0) Share

Report

Posted on by khudeja

305

I have a listpart control on my role center page with source table containing fields "ReturnDateTime" and "DueDateTime". I want to filter those records which have the condition ReturnDateTime > DueDateTime. I used SetFilter function in OnOpenPage trigger of the listpart as follows:

SetFilter(ReturnDateTime, '>%1', DueDateTime);

But it is not working. As far as I observed, it fetches the records which have values in the above fields and leaves the ones with empty values in them. It also brings records with ReturnDateTime lesser than DueDateTime which I don't need. Can someone please suggest what I am doing wrong?

Thanks in advance!

Regards

Khudeja

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Avinash B 1,455 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

if your record has both the fields "ReturnDateTime" and "DueDateTime", then the DueDateTime will also change per each record. May be due to that your filter is not working.

I feel the DueDateTime should be fixed for the filter.

Also to avoid empty values you can try the below code.

SetFilter(ReturnDateTime, '>%1|<>%2', DueDateTime,0DT);

Cheers

Avinash B

Was this reply helpful? Yes No