rayrover00
asked on
Identify the first and last day of the current month in Crystal Reports
I am using the following code in a formula field in Crystal Reports (ver. 8.5):
Local DateVar Start := Date (2008,02,01); // place your Starting Date here
Local DateVar End := Date (2008,02,29); // place your Ending Date here
In this example I statically set the Start date to February 1, 2008 and the End date to February 29, 2008. The variables get used elsewhere. What I need to do is have the Start and End dates dynamically change to whatever the current month is using "currentdate" in Crystal. Anyone know how to do that?
Local DateVar Start := Date (2008,02,01); // place your Starting Date here
Local DateVar End := Date (2008,02,29); // place your Ending Date here
In this example I statically set the Start date to February 1, 2008 and the End date to February 29, 2008. The variables get used elsewhere. What I need to do is have the Start and End dates dynamically change to whatever the current month is using "currentdate" in Crystal. Anyone know how to do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was awesome!! Thanks!