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

(0) Share

Report

Posted on by jdrco

481

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 (1)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

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