<div>
biko,<br />
I have tried your code<br />
RUNSHEET_HISTORY.RUN_DATE<br />
&nbsp;&amp; it doesn't work for me!<br />

</div>


biko,
I have tried your code
RUNSHEET_HISTORY.RUN_DATE
 & it doesn't work for me!


<div>
biko,<br />
I have tried your code<br />
crystalreport1.selectionfo<wbr />rmula = &quot;{tblrpt.somedate} = date(1998,05,02)&quot; <br />
<br />
&nbsp;&amp; it doesn't work for me!<br />

</div>


biko,
I have tried your code
crystalreport1.selectionformula = "{tblrpt.somedate} = date(1998,05,02)"

 & it doesn't work for me!


<div>
<div class="content wysiwyg-content">
Dear sir,<br />
Now, I use Microsoft Access 95 as my database and Visual Basic 4.0. After I finished my crystal report. I try to select group of record with SelectionFormula . But I can't get any report after I try to send in a date format. How can I solve this problem? I have tried for several ways which I know but it's not work..<br />
<br />
Such as;<br />
<br />
crystalreport1.selectionfo<wbr />rmula = &quot;{tblrpt.somedate} = #&quot; &amp;&nbsp;format(maskedbox1.text, &quot;mm/dd/yy&quot;) &amp;&nbsp;&quot;#&quot;<br />
<br />
or <br />
<br />
crystalreport1.selectionfo<wbr />rmula = &quot;{tblrpt.somedate} = #&quot; &amp;&nbsp;cvdate(maskedbox1.text) &amp;&nbsp;&quot;#&quot;<br />
<br />
or <br />
<br />
crystalreport1.selectionfo<wbr />rmula = &quot;{tblrpt.somedate} = &quot;&nbsp;&amp; cvdate(maskedbox1.text) <br />
<br />
PS. I format my date as short date format.
</div>
</div>


Dear sir,
Now, I use Microsoft Access 95 as my database and Visual Basic 4.0. After I finished my crystal report. I try to select group of record with SelectionFormula . But I can't get any report after I try to send in a date format. How can I solve this problem? I have tried for several ways which I know but it's not work..

Such as;

crystalreport1.selectionformula = "{tblrpt.somedate} = #" & format(maskedbox1.text, "mm/dd/yy") & "#"

or 

crystalreport1.selectionformula = "{tblrpt.somedate} = #" & cvdate(maskedbox1.text) & "#"

or 

crystalreport1.selectionformula = "{tblrpt.somedate} = " & cvdate(maskedbox1.text) 

PS. I format my date as short date format.

Problem with Date format in crystal report

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.