查询报表：代码案例-超期天数

案例报表 5月前 15

T0.[TaxDate],
	  datediff(d, T0.[TaxDate], GetDate()) AS '超期日期',
	  CASE WHEN  (
		datediff(d, T0.[TaxDate], GetDate())
	) > 0  THEN  '超' + ' ' +   CAST (
		(
			datediff(d, T0.[TaxDate], GetDate())
		) AS nvarchar
	)   + '天'  
WHEN (
	datediff(d, T0.[TaxDate], GetDate())
) < 0  THEN
	'剩' + ' ' + CAST (
		(
			datediff(d, GetDate(), T0.[TaxDate])
		) AS nvarchar
	) + '天'
END AS '超期'

声明：欢迎来到五六零学院。