Iam trying to calculate the Contract end date in Opportunity. I have the Contract start date (which is equal to the opportunity Close date) and Contract term (in years). Can you help me in deriving the formula to calculate the Contract end date?
eg: Close date = 12/30/2007 Contract term (in years): 1 Hence: Contract End Date = 12/30/2008
Iam trying to calculate the Contract end date in Opportunity. I have the Contract start date (which is equal to the opportunity Close date) and Contract term (in years). Can you help me in deriving the formula to calculate the Contract end date?
eg: Close date = 12/30/2007 Contract term (in years): 1 Hence: Contract End Date = 12/30/2008
I have tried to add Products to Opportunities via the Excel connector, but the Pricebook and Pricebook Entry IDs are system generated and I can't seem to be able to add.
For checking of contact duplicates before inserting them is fine ,its works fine as i had written a before insert trigger for the same.
But i need something extra in the before insert trigger ........
1. To display the Account Name of already existing Contact Name in SFDC (Done--Achieved)
2. A message or alert with yes or no button saying tht 'would u like to proceed with creating of this contact ,though its duplicate exists' and if he clicks yes then the contact shld be created..overriding the before insert trigger written by me ... (Help Needed on this)
Message Edited by Chirag Mehta on 05-07-200701:46 AM
I am trying to update the RecordType field for Opportunities Object using Apex Data Loader, but I get the following error. "Insufficient Access rights on object id"
I was able to insert the new opportunities using Data Loader, but updating the recordType field fails.
Because of the limitations on the formula field,
this would require creating three fields: “Days Since Closed”,
“Days Since Open” and “Age”. Only the “Age”
field would be visible on the page layout the others would have to be
hidden.
Formula Fields with Number data type and zero
decimal points. Below are the formula values for the fields.
Days Since
Closed = TODAY() - {!CloseDate}
Days Since
Open = NOW() - {!CreatedDate}
Age
= IF(ISPICKVAL({!StageName},"Closed
Lost"),{!Number_Since_Open__c} - {!Days_Since_Closed__c},NOW()
- {!CreatedDate})
