my requirement is-
"SmartLaborII Work Order End Date" is NOT greater than "SmartLaborII Previous Work Order End Date"]-
and the code I'm using is-
datediff(day,[WorkForce_WorkOrder].[Work Order End Date_WO]
,[WorkForce_WorkOrder].[Previous Work Order End Date_WO] )
Since I'm new to TSQL world, wanted to know if my above code for my requirement is correct ? if not what should be the right code and why please?