<div>
do not declare your parameter as date, declare parameter as text and then in your query - WHERE clause you convert the text into date using CDate() function.<br />
<br />
i.e.<br />
PARAMETERS mFromDt Text(125), mTODt Text(125);<br />
SELECT * FROM tbl_Master WHERE FromDate &gt;= cdate(mFromDt) AND ToDate &lt;= cdate(mToDt)<br />
<br />
pass your parmater as text in vb.<br />
<br />
i hope this will solve your problem.
</div>


do not declare your parameter as date, declare parameter as text and then in your query - WHERE clause you convert the text into date using CDate() function.

i.e.
PARAMETERS mFromDt Text(125), mTODt Text(125);
SELECT * FROM tbl_Master WHERE FromDate >= cdate(mFromDt) AND ToDate <= cdate(mToDt)

pass your parmater as text in vb.

i hope this will solve your problem.

<div>
Please maintain this old open question:<br />
<br />
<a href="https://www.experts-exchange.com/questions/20613756/Custom-Seperators-for-the-Number-Format.html" rel="ugc">https://www.experts-exchange.com/questions/20613756/Custom-Seperators-for-the-Number-Format.html</a><br />
<br />
Thanks,<br />
Anthony
</div>


Please maintain this old open question:

https://www.experts-exchange.com/questions/20613756/Custom-Seperators-for-the-Number-Format.html [https://www.experts-exchange.com/questions/20613756/Custom-Seperators-for-the-Number-Format.html]

Thanks,
Anthony

<div>
My link should have solved the problem.<br />
<br />
mlmcc
</div>


My link should have solved the problem.

mlmcc

<div>
<div class="content wysiwyg-content">
I am using a Visual Basic Application as the Front End and Crytsal Reports as the Reporting tool. &nbsp;I want to generate some reports on the base of the dates provided by the user, for that I have to pass the &quot;from date&quot; and the &quot;to date&quot; to the Crystal Reports as parameters. &nbsp;But every time I pass the SQL query to the crystal reports alongwith the parameters it always gives me an error and never the correct report with the data is generated. &nbsp;So can u tell me how can I pass the SQL query alongwith the dates as the parameters to the Crystal Reports. &nbsp;I am using VB 6.0 and Crystal Reports 8.0
</div>
</div>


I am using a Visual Basic Application as the Front End and Crytsal Reports as the Reporting tool.  I want to generate some reports on the base of the dates provided by the user, for that I have to pass the "from date" and the "to date" to the Crystal Reports as parameters.  But every time I pass the SQL query to the crystal reports alongwith the parameters it always gives me an error and never the correct report with the data is generated.  So can u tell me how can I pass the SQL query alongwith the dates as the parameters to the Crystal Reports.  I am using VB 6.0 and Crystal Reports 8.0

Passing Parameters to Seagate Crystal Reports

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.