title: Default date is not what I expected for a Date variable initialized with time only
body: <p>With a <code>Date</code> variable, apparently it defaults to <code>January 1, 0001</code> if you don't enter a date in a date/time literal. </p>
  
  <p>However, if I choose to display that default date, it shows the date <code>December 30, 1899</code> which isn't even an acceptable date in Excel. Here's the code:</p>
  
  <pre><code>Sub TimeOfBirth()  
    Dim BirthTime As Date  
    BirthTime = "2:00:00 PM"  
    MsgBox Format(BirthTime, "yyyy-mm-dd")  
  End Sub
  </code></pre>
  
  <p>Can anyone explain this? I get that VBA stores a much greater range of dates, but I don't understand why <code>December 30, 1899</code> is being displayed?</p>
  
  <p>What's the math/logic there?</p>