title: Changing or add the time to a Date in VBA
body: <p>I am working with a VBA project for Outlook. The project is looking at Calendar appointments and comparing them to dates pulled out of an SQL database and stored in a Date variable.</p>
  
  <p>Currently when the dates come out of the SQL database they not have any Time component to them but I would like to add one to it.</p>
  
  <p>For example out of the SQL query comes "07/03/2018" and I would like to be able to set this as "07/03/2018 09:00:00" and various other times of the day.</p>
  
  <p>Is there a way of doing this without converting the date variable to a string and just adding the time on at the end? This is because I would like to be able to use Date based functions such as DateAdd etc. on the variable later in the program.</p>