BOS开发单据,编写报表如何将过滤条件显示为长日期字段
金蝶云社区-150xxxx9749
150xxxx9749
0人赞赏了该文章 331次浏览 未经作者许可,禁止转载编辑于2019年08月23日 15:45:36

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<='########'修改为长日期字段?