<div>
Best guess without seeing the data types for tblDate is that the Date field is a date/time data type, but your query (view) is returning a string (this is the return data type of the format function) which causes the issue when you attempt to join the two.
</div>


<div>
1. Date is a reserved word and should not be used for a name<br />
<a href="http://allenbrowne.com/AppIssueBadWord.html" rel="ugc">http://allenbrowne.com/AppIssueBadWord.html</a><br />
<br />
2. Date is stored internally as a double-precision number (exponential format -- 1.23 x 10^^n) and is, therefore, not accurate for exact comparisons (including linking)<br />
<br />
3. Dates can also have a time component so they are not whole numbers<br />
<br />
4. please paste in your equation because the screenshot does not show it all<br />
<br />
5. names for calculated fields CANNOT be the same as a name in any source (ie: Date -- already a bad name anyway, as mentioned above)<br />
<br />
6. using the FORMAT function converts values to a string (text) -- instead, use the format PROPERTY (right-click in a column and set Format on the Property Sheet)
</div>


<div>
In a Join ... the Data Types must be <b>EXACTLY </b>the same .... check that.
</div>


<div>
Data Type looks same but expression might be causing the error.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116690/Snap944.jpg" target="_blank" title="Snap944.jpg (40 KB)"><img alt="Snap944.jpg" class="file-block lazyload" style="max-width: 520px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116690/Snap944.jpg" /></a><a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116691/Snap943.jpg" target="_blank" title="Snap943.jpg (60 KB)"><img alt="Snap943.jpg" class="file-block lazyload" style="max-width: 627px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116691/Snap943.jpg" /></a>
</div>


Snap944.jpg

Snap943.jpg

<div>
Even though the two fields may look the same, because the Date column in your WorkHour query is a string (text) data type, it cannot be used when joining to a Date/Time data type.<br />
<br />
If you are using the format to remove the time component of the date/time, replace it with DateValue([Start Time])
</div>


<div>
&quot;Data Type looks same but expression might be causing the error.&quot;<br />
You need to open table in Design view ....
</div>


<div>
i'm getting mismatch error from this expression;<br />
Date: DateValue(Format([Start Time],&quot;yyyy/mm/dd&quot;))
</div>


<div>
getting error<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116692/Snap945.jpg" target="_blank" title="Snap945.jpg (43 KB)"><img alt="Snap945.jpg" class="file-block lazyload" style="max-width: 490px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116692/Snap945.jpg" /></a>
</div>


Snap945.jpg

<div>
<div class="content wysiwyg-content">
i have a expression but when i create other query, i get this error.<br />
would you advise me?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116685/Snap936.jpg" target="_blank" title="Snap936.jpg (31 KB)"><img alt="Snap936.jpg" class="file-block lazyload" style="max-width: 398px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116685/Snap936.jpg" /></a><a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116686/Snap937.jpg" target="_blank" title="Snap937.jpg (54 KB)"><img alt="Snap937.jpg" class="file-block lazyload" style="max-width: 521px;" data-src="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116686/Snap937.jpg" /></a>
</div>
</div>


Snap937.jpg

Snap936.jpg

i have a expression but when i create other query, i get this error.
would you advise me?


Microsoft Access Date format

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.