<div>
You could try DateSerial.<br />
<br />
DateSerial(Year({?Start Date}), Month({?Start Date})+3, 0)
</div>


You could try DateSerial.

DateSerial(Year({?Start Date}), Month({?Start Date})+3, 0)

<div>
I actually went with this. &nbsp;Do you see any issue with it? <br />
<br />
and &quot;LicensePayments&quot;.paymentd<wbr />ate &nbsp;between {?Start Date} and EOMonth( DATEADD(month,2,{?Start Date}))
</div>


I actually went with this.  Do you see any issue with it?

and "LicensePayments".paymentdate  between {?Start Date} and EOMonth( DATEADD(month,2,{?Start Date}))

<div>
No, to be honest I didn't realise EOMONTH was available in Crystal Reports.
</div>


No, to be honest I didn't realise EOMONTH was available in Crystal Reports.

<div>
Sorry I'm using sql in a command to retrieve data. &nbsp;Should of explained that better. &nbsp;<br />
<br />
But now I have a reference from doing it in Crystal too!<br />
<br />
Thanks
</div>


Sorry I'm using sql in a command to retrieve data.  Should of explained that better.  

But now I have a reference from doing it in Crystal too!

Thanks

<div>
How can I give some points to Norie even tho I'm using my own solution?
</div>


How can I give some points to Norie even tho I'm using my own solution?

<div>
<div class="content wysiwyg-content">
I have this line of code where I need to find records that fall between two dates. &nbsp;There is only one parameter that is supplied which is the starting date for the period. &nbsp;I need to find the last date of the ending month.<br />
<br />
Example: &nbsp; Start Date = 07/01/2019 &nbsp; and the last date should calculate out to 09/30/2019<br />
<br />

<pre><code id="code-10-29161846-1">and &quot;LicensePayments&quot;.paymentdate  between {?Start Date} and DATEADD(month,2,{?Start Date})</code></pre>
<br />
I'm using this as part of a command in Crystal Reports.
</div>
</div>


I have this line of code where I need to find records that fall between two dates.  There is only one parameter that is supplied which is the starting date for the period.  I need to find the last date of the ending month.

Example:   Start Date = 07/01/2019   and the last date should calculate out to 09/30/2019

(CODE)

I'm using this as part of a command in Crystal Reports.

Calculate Last Date of Month

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.