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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In 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