<div>
If it is a Date field, no CDate is needed:<br />
<br />

<pre><code id="code-20-42665904-1">Date Completed: [QryReportDetail].[Date Completed]</code></pre>
And it can be <i>Null </i>as well.
</div>


If it is a Date field, no CDate is needed:



Date Completed: [QryReportDetail].[Date Completed]

And it can be Null as well.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I get &quot;Data type mismatch in criteria expression&quot; error message when I run below function.<br />
<br />
Date Completed: CDate([QryReportDetail].[D<wbr />ate Completed]).<br />
<br />
I can't find anything wrong in the column(Actual there the values are null for this column, still I need to apply this function in case it get values in the future). Also, this function worked fine with other columns with character dates.<br />
<br />
Please have a look.<br />
<br />
Thanks<br />
K
</div>
</div>


Hi,

I get "Data type mismatch in criteria expression" error message when I run below function.

Date Completed: CDate([QryReportDetail].[Date Completed]).

I can't find anything wrong in the column(Actual there the values are null for this column, still I need to apply this function in case it get values in the future). Also, this function worked fine with other columns with character dates.

Please have a look.

Thanks
K

Data type mismatch in criteria expression on Access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.