Insert/update datetime from VB6 to Sql Server

Question

In MS ACCESS

itmarr(0, 0) = "bill_date"

itmarr(1, 0) = TxtDate.Text

 

IN SQL SERVER

itmarr(0, 0) = "bill_date"

itmarr(1, 0) = Format(TxtDate.Text, "dd MMM yyyy")

ERROR SHOW IN SQL SERVER]

the conversion of a varchar data type to a datetime data type resulted in an out-of-range value