Home Forums SQL Server 2008 T-SQL (SS2K8) Urgent help need to verify DateDiff is correct? RE: Urgent help need to verify DateDiff is correct?

  • March 7, 2013 at 2:46 pm

    #1594707

    If they are DATE or DATETIME data types why not just do this?

    [WorkForce_WorkOrder].[Work Order End Date_WO] <= [WorkForce_WorkOrder].[Previous Work Order End Date_WO]