web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to filter table re...

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

Answered

How to filter table record and data item to be in a month range?

(0) Share

Report

Report

Posted on by jdrco

485

I want to grab posted invoices based on its date. For example, I only want to grab invoices within the range of May 2022 (2022/05/01 - 2022/05/31).
How would I do this using SetRange/SetFilter on a table record?
How would I do this using a Dataitem that already has a DataItemTableView and DataItemLink property (I'm hoping I can add onto these properties already set)?
This is the current properties I have on my data item:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi jdrco ,

Please use below line of code.

DataItemTableView = SORTING("Bill-to Customer No.") where("Posting Date" = filter(20220501 .. 20220531));

Hope it will help you.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

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

#1

OussamaSabbouh 563 Super User 2026 Season 2

#2

YUN ZHU 374 Super User 2026 Season 2

#3

Grigorios Mavrogeorgis 331 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans