怎样选择一个时间到另一个时间之间的记录

[colee]

这两个时间都是人工输入的变量

[colee]

我用过以下两种方式都是不行
我用的是ASP+Access

rs1.open "select * from test where date_time Between "& former_date &" and "& latter_date,conn,3,3
rs1.open "select time,CONVERT(VARCHAR(10),date_time,9) from test ",conn,3,3

[coo_key]

这样试试
rs1.open"select * from test where date_time>"&cdate(former_date)&" and date_time < "&cdate(latter_date)&",conn,,3,3

[cmsoft]

sql="select * from test where date_time Between "#& former_date &#" and "#& latter_date &#""
rs1.open sql,conn,1,1

[wpmsoft]

如果你的变量formet_date和latter_date均是合法的时间，则在sql语句中可以这样子

sql = "select * from test where date_time >= '" & former_date & "' and date_time <= '" & latter_date & "'"

主要是不知道你的变量是怎么定义的，怎么赋予的值。你可以把他们用response输出来看一下，然后自然就知道sql语句应该怎么写了。

[colee]

这种也是不行的
select * from test where cint(datediff('d',date_time,former_date))<0
因为ACCESS版本会变动的原因，下面这个也不通用

先rs1.open "select * from test"
再if date_time>former_date and date_time<latter_date then

[cmsoft]

access时间用##

[colee]

cmsoft(韦小宝是我的老乡) 的方法不错，
可不可以解释一下加＃符号的原因？

[hujunx]

RSEvent.Source = "SELECT * FROM activity where act_time >= '2002-01-01'" ;

RSEvent.Source = "SELECT * FROM activity where act_time >= #2002-01-01#" ;

RSEvent.Source = "SELECT * FROM activity where act_time >= #2002/01/01#" ;

RSEvent.Source = "SELECT * FROM activity where act_time >= 2002101";


RSEvent.Source = "SELECT * FROM activity where act_time >= '2002101'";


以上语句在 asp和 JavaScript中都是错误的，如何解决????