主题：sql语句中如何返回控件中的日期?

Dim dtp1 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker1")
Dim dtp2 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker2")
Dim v1 As Date = dtp1.value
Dim v2 As Date = dtp2.value

dim sql as string

sql = "select  * from {表A} where 日期 BETWEEN #v1# And #v2# "
最后一句红色部份(表示日期控件中大于或等于V1 and 小于或等于V2)应该怎样写?