check date plus 90 days
Posted on 2007-11-26
I have a query where I need to check if the date stored in the database is still active. The formula to determine if the date is still active is if the if the Contract_End_c field is not past todays date plus 90 days.
The date stored in the database is in the format: mm/dd/yyyy
This is what I was trying:
Select a.AccountNumber, a.Contract_End__c from Account a WHERE a.AccountNumber = '123456' AND a.Contract_End_c <= DATEADD(dd, 90, getdate())
Thanks for any help.