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:

Business Central

All responses (3)

Answers (1)

Suggested answer

Mohana Yadav 59,135 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,135 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-