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.

1. Date is a reserved word and should not be used for a name
http://allenbrowne.com/AppIssueBadWord.html

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)

3. Dates can also have a time component so they are not whole numbers

4. please paste in your equation because the screenshot does not show it all

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)

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)

In a Join ... the Data Types must be EXACTLY the same .... check that.

Data Type looks same but expression might be causing the error.

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.

If you are using the format to remove the time component of the date/time, replace it with DateValue([Start Time])

"Data Type looks same but expression might be causing the error."
You need to open table in Design view ....

i'm getting mismatch error from this expression;
Date: DateValue(Format([Start Time],"yyyy/mm/dd"))

getting error