Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
kkoehle@valuedrugco.com 4/17/2018 2:44:12 PM

SSRS subscription - finding the start and end dates each month

I have a report that has several parameters, including the start and end date.  It is a monthly report that I want to produce with a subscription.

It will run on the 3rd of each month and the data it's looking for is always for the previous month.

Best way to have it calculate the start and end dates without user intervention?

 

Example:   Report will run on May 3, 2018.   I want the start date to be April 1, 2018 and end date April 30, 2018.

The report will run again on June 3, 2018.   Start date = May 1, 2018   End date = May 31, 2018

 

 

Version: GP 2015
Section: SQL Scripts, SSRS








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables