<div>
Assuming your parameter is named dateparm, you refer to the entire parameter as {?dateparm} in formulas.<br />
<br />
To pass the date to SQL, you may need to parse the parameter which is of date/time type to be of date type only using datevalue({?dateparm}). &nbsp;Your version os SQL may also require that the date appear as a string, in which case your where clause would be <br />
<br />
&quot;...where accDate = '&quot; + totext({?dateparm},&quot;mm/dd/<wbr />yyyy&quot;)<br />
<br />

</div>


Assuming your parameter is named dateparm, you refer to the entire parameter as {?dateparm} in formulas.

To pass the date to SQL, you may need to parse the parameter which is of date/time type to be of date type only using datevalue({?dateparm}).  Your version os SQL may also require that the date appear as a string, in which case your where clause would be

"...where accDate = '" + totext({?dateparm},"mm/dd/yyyy")



<div>
<div class="content wysiwyg-content">
Hi,<br />
How do I use the Date parameter field in a report in the select query of the same &nbsp;report.<br />
ie,<br />
I am calling the report from VB. Yes the parameter passes and I can get it in the report.<br />
<br />
My SQL Query of the crystal report should look something like:<br />
select &lt;records&gt; where accDate = &lt;parameter field&gt;<br />
<br />
Thanks,<br />
Ram
</div>
</div>


Hi,
How do I use the Date parameter field in a report in the select query of the same  report.
ie,
I am calling the report from VB. Yes the parameter passes and I can get it in the report.

My SQL Query of the crystal report should look something like:
select <records> where accDate = <parameter field>

Thanks,
Ram

Date parameter in select query of the CrysReport

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.