News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Filter by date, based ...

Small and medium business | Business Central, N...

Suggested answer

Filter by date, based in a start date and ending date

(0) Share

Report

Report

Posted on by Community member

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 86,253 Super User 2025 Season 1 on at

Like (0)

Report

Hi community , I wana make a Filter by date, based in a start date and ending date

Hi, what problems did you encounter? You can execute the following method in the OnValidate Trigger of the date, so that the result will change.

Record.SetRange(Any [, Any] [, Any]) Method:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-setrange-method?wt.mc_id=DX-MVP-5004336

SETFILTER Function (Record):

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-setfilter-method?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans