1

Topic: Script of delay of submission of the document

Good afternoon, guys would prompt please a script that it was possible to see document feeding delay in  MSSQL. The document has a date started of its action DBEG for example with 9/1/2017 and there is a date of its input in database DTIN for example 9/3/2017, . the document has been submitted only in a day it is delay how to select such documents? If the dock has been submitted 9/2/2017 delay it is not considered.

2

Re: Script of delay of submission of the document

SQL_Bear;

select *
from [yourtable]
where datediff (day, DBEG, DTIN)> 1

3

Re: Script of delay of submission of the document

Minamoto, low to you bow, thanks!