February 27th, 2017, 03:30 PM
Join Date: Jun 2011
Time spent in forums: 1 h 8 m 43 sec
Reputation Power: 0
How do I select an expiration date in 2016 but check to see if there is one in 2017?
Iím trying to run a query of expiration dates in 2016 but if they have a 2017 expiration date I donít want them to show up.
WHEN LIC.License_Expiration_Date > '1/1/2017' THEN LIC.License_Expiration_Date
FROM [dbo].[FacilityLocations] FAC
INNER JOIN [dbo].[License_Tracking] LIC ON FAC.FacilityID = LIC.FacilityID
Thanks in advance for any help.