Refer this example,
declare @field1 datetime,@field2 datetimeset @field1 = getdate()set @field2 = getdate() - 4Select Case when datediff(d,@field1,@field2) > 3 then 'late' else 'on time' end [Status]
Regards, RSingh
No comments:
Post a Comment