Datetime Inner Join with Date - dbplyr - Microsoft SQL Server

[djslp]

After some more troubleshooting, I found a solution:

a %>%
    mutate(newDate = as.Date(DateTime)) %>%
    inner_join(b, by = c('newDate' = 'Date'))

A tally count confirmed the correct amount of rows returning.