I am doing a Select that contains a DATEADD and I want to get the records 330 days after the Date in the column DatTimeIssued in table Record. Here is the code I am using:
SELECT No, CustomerID
WHERE (LicenceStatus = 'Active') AND (RenewalStatus = 'Current') AND (LicenceDateTimeIssued = DATEADD(DAY, 330, LicenceDateTimeIssued))
I am not getting any records returned but I should be as the data fits the query criteria.
Anyone know what I am doing wrong ?