Only need to enter date which is for 3 months from today

(0) Share

Report

Posted on by Shankar

Hi, I have many records in my sales order , which is also seen in my new local table, due to this it's taking to much time to load, so I want to show only 3 months data from today in my table, how can we manage that?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Mohana Yadav 61,248 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Please use CALCDate

learn.microsoft.com/.../calcdate-function--date-

Was this reply helpful? Yes No
Shankar 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks as I have used systemcreatedat date time where I can only enter current data, so if I want to, not show data which is more than 3months so I can use calcdate function? Right

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,248 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, you can filter using <-3M>

Was this reply helpful? Yes No