Hi, My QL is rusty and I'd like some help to complete this. Should be easy for the experts!
What I'm trying to do below is this
If the dbo.NewCanvass.NextContact
Date is greater than 30 days past the current date then display the text 'Red'
Once I get this working I can write the rest of the statement myself. Thanks
CASE WHEN (DATEADD(dd, DATEDIFF(dd, 0, dbo.NewCanvass.NextContactDate), 0) = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 30)) THEN 'Red' as NextContactDate