By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Report Designer
5
Posts
2
Users
1
Reactions
5,042
Views
January 24, 2018 4:19 pm
Whenever I run a report, I want it to run to the previous month. Not sure what formula to use in the report designer
4 Replies
January 24, 2018 4:23 pm
What report are you using? Is it an out-of-the-box report?
January 24, 2018 4:40 pm
January 24, 2018 5:11 pm
Try adding a DateAdd function to the StartDate and EndDate parameters.
For StartDate, put this in the Default value field:
=DateAdd(DateAdd(Report.GetDefExt('AccessInfo.BusinessDate'), 'd', -(Day(Report.GetDefExt('AccessInfo.BusinessDate')) - 1)),'m',-1)
For EndDate, put this in the Default value field:
=DateAdd(Report.GetDefExt('AccessInfo.BusinessDate'),'m',-1)
February 7, 2018 5:02 pm