View the original community article here
Last tested: Jan 21, 2019
We recommend against joining on date, because it is incredibly non performant.
However, if you wants to do it anyway, they need to use the raw timeframe to ensure that time zone conversion happens properly.
Merge results should alleviate most join-on-date use cases.