this is my query
SELECT ID, Contractname, triggerdate, Amount, ClientID FROM legalcontract
triggerdate is the date where we need to follow up to client for possible renewal. i want to add to my query a field called 30days which is 30 days before the triggerdate.
how can u add that programmaticaly in tsql?