关于取记录集时，取指定日期范围内记录的问题，在线等待！

[net_jun]

rsStr = "select bNumber as 单据号,bCuName as 客户姓名,bOpPro as 业务类型,bPrice as 金额,bMemo as 备注,bDatatime as 制单时间 from bill where bDataTime between " & "#" & stardata & "#" & " and " & "#" & enddata & "#"

我怎么也不能取到正确的数据，bDatatime 字段的数据类型为日期型

stardata,enddata为字符串型变量由 DTpicker 控件取得。

能给个范例我吗？

[射天狼]

rsStr = "select bNumber as 单据号,bCuName as 客户姓名,bOpPro as 业务类型,bPrice as 金额,bMemo as 备注,bDatatime as 制单时间 from bill where bDataTime between #" & format(stardata,"yyyy/mm/dd") & "# and #" & format(enddata, "yyyy/mm/dd") & "#"

还有就是你数据库里这两日期是什么格式,长日期还是短日期!?

[strongfisher]

如上

[net_jun]

数据库里就一个字段，是短日期的
有关系吗？

[net_jun]

cuizm 的代码是对的，谢谢了！

[zjcxc]

rsStr = "select bNumber as 单据号,bCuName as 客户姓名,bOpPro as 业务类型,bPrice as 金额,bMemo as 备注,bDatatime as 制单时间 from bill where format(bDataTime,""yyyy/mm/dd"" between #" & format(stardata,"yyyy/mm/dd") & "# and #" & format(enddata,"yyyy/mm/dd") & "#"