BOS开发单据,编写报表如何将过滤条件显示为长日期字段
SELECT
ZRQ AS 日期,
GK AS 港口,
JHH AS 计划号,
CD AS 车队,
sum(JZ) as 净重
from(SELECT
t2.FTime as ZRQ,
t1.FText6 as GK ,
t2.FText as CM,
t2.FText1 as JHH,
t2.FText4 as CD,
t2.FDecimal as JZ
FROM t_BOS200000004 t1
INNER JOIN t_BOS200000004Entry2 t2 ON t1.FID= t2.FID AND T1.FText6 like '%京唐港%'
and t2.FTime>='********' and t2.FTime<='########')v group by JHH,ZRQ,GK,CD
如何将日期过滤字段t2.FTime>='********' and t2.FTime<='########'修改为长日期字段?
字符串解决
直接SQL关键字中数据类型没有长日期类型,只有日期型和时间型,如何解决?
BOS开发单据,编写报表如何将过滤条件显示为长日期字段
SELECTZRQ AS 日期,GK AS 港口,JHH AS 计划号,CD AS 车队,sum(JZ) as 净重from(SELECT t2.FTime as ZRQ, t1...
点击下载文档
本文2024-09-16 16:34:34发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-10149.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章