truncate date when starting a new visit to remove millisecond components to fix mysql bug
(moved this into a different method so that it captures more use cases)