Dynamics 365 CommunityForums Business Central forum Price List Line (7001)...

Price List Line (7001) Filters Date

(0) Share

Report

Posted on by Michel Chacaliaza

Hello everyone, I need to set up a filter for the start date and end date in the purchase price list.
- The start date is equal to or less than the current date (today), and the end date can be empty.
- The end date is equal to or greater than the current date (today), and the start date can be empty.
- The start date is equal to or less than the current date (today), and the end date can have a real date.
- The end date is equal to or greater than the current date (today), and the start date can have a real date.
- Both start and end dates can be empty and still meet the desired date filter.
I hope my explanation is not too complicated.
Can someone please help me with this?

PriceListLine.SetRange(/Starting Date/, WorkDateFilter, 0D);

Categories:

Sales

Development

All responses (1)

Answers (0)

Suggested answer

Michel Chacaliaza 74 on at

Like (0)

Report

Price List Line (7001) Filters Date

Hello, this is what I came up with to get the result; I didn't use the filter for the dates, but I did include it in the conditions within the repeat.