Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select * from table where
(case when table.type = 'imp' then COALESCE(table.VeseelArrDate, Table.ArrDate) else coalesce(table.VesselDepDate,Table.DepDate) end) < dateadd(day,-day(getdate( ))1,getdate( ))
select * from (select *, (case when table.type = 'imp' then COALESCE(table.VeseelArrDate, Table.ArrDate) else coalesce(table.VesselDepDate,Table.DepDate) end) myDate from table) T where T.myDate < dateadd(day,-day(getdate( ))1,getdate( ))