-Dman100-
asked on
check date plus 90 days
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.