SELECT * FROM 订单 where 1=1 ${if(type=="日报"," and date(订购日期)='"+ date +"'",
if(type=="月报"," and strftime('%m',订单.订购日期)='"+ month+"'"+" and strftime('%Y',订单.
订购日期)='"+ year+"'"," and strftime('%Y',订单.订购日期)='"+ year+"'"))}
(type=="日报"," and date(订购日期) 这句错了吧 应该去掉date() 直接是 and 订购日期吧 我是改了查询就好了
30 评论
支持在单元格里面操作吗
赞 0 2024-04-09 14:28
帆软strftime报凑为什么
赞 0 2024-01-29 12:08
SELECT * FROM 订单 where 1=1 ${if(type=="日报"," and date(订购日期)='"+ date +"'",
if(type=="月报"," and strftime('%m',订单.订购日期)='"+ month+"'"+" and strftime('%Y',订单.
订购日期)='"+ year+"'"," and strftime('%Y',订单.订购日期)='"+ year+"'"))}
(type=="日报"," and date(订购日期) 这句错了吧 应该去掉date() 直接是 and 订购日期吧 我是改了查询就好了
赞 0 2023-06-06 16:40
大哥，为什么下载模板，月报和日报的数据是空的呢
赞 0 2023-05-30 17:57
下载了模板，你这个在年报的时候数据是可以的，但是月报和日报没有数据联动
赞 0 2023-05-30 17:06