News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Only need to enter dat...

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

Answered

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

(0) Share

Report

Report

Posted on by Shankar

75

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

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

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

yes, you can filter using <-3M>
Shankar 75 on at

Like (0)

Report

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

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
Verified answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (1)

Report

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

Please use CALCDate

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans