判断日期问题请大家帮忙

[why0825]

我想查询本年年初到本年本月月底数据，我的日期怎么判断

[leo963258]

select * from table wehre datetime #2005-1-1# between #2005-12-30#

[踏实每一步]

select * from Table where 时间字段 between '2005-1-1' and '2005-12-30'

[jarraytan]

昏。楼上的两位。楼主说的是到本月月底哦！

"select * from table wehre datetime >= #" & year(date()) &"-1-1# and datetime <#" & year(date()) & "-" & month(date())+1 & "-1#"

如果只要2005年的话就简单了。
"select * from table wehre datetime >= #2005-1-1# and datetime <#2005-" & month(date())+1 & "-1#"

[why0825]

不是查询指定日期
而是先判断然后查询期出结存
我是想用本年年初的数据减每个月月末的数据就是期初结存
那么我怎么设定日期

[jarraytan]

"select * from table wehre datetime >= #" & year(date()) &"-1-1# and datetime <#" & year(date()) & "-" & month(date())+1 & "-1#"

本年年初到本月月末的数据！

[icefire988]

<%
dim datetime,tyear,tmonth,tday,ftime,ltime
datetime = date()
tyear = year(datetime)
tmonth = month(datetime)
ftime = tyear & "-01-01"
select case tmonth
case 1,3,5,7,8,10,12
tday = 31
case 4,6,9,11
tday = 30
case 2
if (tyear mod 4 =0 and tyear mod 100 <>0 and tyear mod 400 = 0) then
tday = 29
else
tday = 28
end if
end select
ltime = tyear & "-" & tmonth & "-" & tday
'access
sql = "select * from table where datetime between #" & ftime & "# and #" & ltime & "#"
'mssql
sql = "select * from table where datetime between '" & ftime & "' and '" & ltime & "'"

%>

[goodstuday]

boythl(沙漠孤狐【若你的问题得到解决，请尽快结贴，谢谢】)
"select * from table wehre datetime >= #" & year(date()) &"-1-1# and datetime <#" & year(date()) & "-" & month(date())+1 & "-1#"
-------------------------------------------------
这完全可以解决楼主的问题了啊

[dafei0320]

year(date())
month(date())
………………
楼住还不结啊？？