'subscript is out of range'

[SamT]

Where exactly should I be adding the "CDate(0) = 12:00:00AM"?

Nowhere.That was a statement of fact. If you convert zero to a date, you get 12:00:00AM as the result

Example code

Sub TestDateZero()
MsgBox CDate(0)
End Sub