Convert YYYY-MM-DD into Interger in Select, and still recognize INT date in the Join

SQLServerCentral » Latest topics

Convert YYYY-MM-DD into Interger in Select, and still recognize INT date in the Join

Hello, I'm able to convert a yyyy-mm-dd formated DATE column into an Integer, but when I reference that column in the join I still get: Operand type clash: date is incompatible with int.
The Int is in the Dim_Date table, the key column, and the DATE

more info...