select hy.hy_id as hyid,hy.hy_xm as hyxm,kjb.kjb_mc as hyjb,format(hy.hy_csrq,"mm月dd日") as hycsrq
from hy inner join kjb on hy.hy_kjb=kjb.kjb_id
where (not hy.hy_csrq is null) and ((DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date()),hy.hy_csrq)) BETWEEN 0 AND 15) or (DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date())+1,hy.hy_csrq)) BETWEEN 0 AND 15)) and hy_zt<>1
from hy inner join kjb on hy.hy_kjb=kjb.kjb_id
where (not hy.hy_csrq is null) and ((DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date()),hy.hy_csrq)) BETWEEN 0 AND 15) or (DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date())+1,hy.hy_csrq)) BETWEEN 0 AND 15)) and hy_zt<>1
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
