VB中dtpicker日期控件中怎么用法啊？……

[99percent]

如果用这个控件来做查询那语句怎么写法啊？
我想从里面选取日期进行查询。
-----------------------------------
新手上路请高手能帮帮，谢过。

[Lzh_lee]

dtp.value就是它的值
TimeStr = " Pay_date < #" & CDate(DateValue(DTPDateEnd.Value) & " " & TimeValue(DTPTimeEnd.Value)) & "# and pay_date > #" & CDate(DateValue(DTPDateStart.Value) & " " & TimeValue(DTPTimeStart.Value)) & "#"

[有哥]

这要快得多：
TimeStr = " Pay_date between #" & format(DTPDateStart.Value,"yyyy-MM-dd") & "# and #" & format(DTPDateEnd.Value,"yyyy-MM-dd") & "#"

[of123]

strSQL = "select * from yourtabel where yourdatefiele between #" & format(DTPStart.Value,"yyyy-mm-dd") & "# and #" & format(DTPEnd.Value,"yyyy-mm-dd") & "#"

[iceberg_zheng]

str = "select * from tabel where date between #" & format(DTPStart.Value,"yyyy-mm-dd") & "# and #" & format(DTPEnd.Value,"yyyy-mm-dd") & "#"