Hi my problem is that i have 2 different unit of time trying to inner join.
how do i solves this?

thanks in advance

[manufacturing_order_reporting].[reported_when] have time yyyy-mm-dd hr:mm:sec
[sales_invoice_log].[invoice_date] have time yyyy-mm-dd

select [sales_invoice_log].[invoice_date],[manufacturing_order_reporting].[reported_when] 
from [manufacturing_order_reporting] [manufacturing_order_reporting]
 inner join [sales_invoice_log] [sales_invoice_log] on ([sales_invoice_log].[invoice_date] = [manufacturing_order_reporting].[reported_when])

Get the inner join to work with 2 different time unit.