The following query may be used in the DB Browser for SQLite to view the visits of a certain rep on a certain date:
SELECT interaction.startTime, visit.endTime, customer.name, interaction.interactiontype, interaction.id from interaction
join customer on customer.id = interaction.customer_id
left join visit on visit.interaction_id = interaction.id
interaction.starttime like '2019-05-07%'
and interaction.username = 'Ian'
interaction.starttime like 'YYYY-MM-DD%'
and interaction.username = 'USERNAME'