You need to sign in to do that
Don't have an account?
sfdc dev 2264
Trigger for DATE overlapping help needed
Hi,
I need help on the following requirement below as follows,
1) I have a account object where contract is another object related to account
2) Contract object is having contract start date and end date which populates to account (start date__c and end date __c)
My scenario is
3)If there are 2 active contract associcated to account and the dates contain
1st Active contracts dates are
start date :1.feb 2017
end date : 31st march 2017
2nd active contract dates are
start date : 1st march 2017
end date : 17th sep 2017
then in this scenatio the first active contract end date should be automatically backdated to the previous month below as follows to avoid overlapping between 2 contracts
1st active contract end date should automatically be changed to
end date :28th feb 2017
start date should remain the same as 1 feb 2017.
basically both contracts end dates and start dates shouldnt fall in same range to avoid overlapping
Help me how to achieve this
please help me with the trigger code
Thanks in advance
I need help on the following requirement below as follows,
1) I have a account object where contract is another object related to account
2) Contract object is having contract start date and end date which populates to account (start date__c and end date __c)
My scenario is
3)If there are 2 active contract associcated to account and the dates contain
1st Active contracts dates are
start date :1.feb 2017
end date : 31st march 2017
2nd active contract dates are
start date : 1st march 2017
end date : 17th sep 2017
then in this scenatio the first active contract end date should be automatically backdated to the previous month below as follows to avoid overlapping between 2 contracts
1st active contract end date should automatically be changed to
end date :28th feb 2017
start date should remain the same as 1 feb 2017.
basically both contracts end dates and start dates shouldnt fall in same range to avoid overlapping
Help me how to achieve this
please help me with the trigger code
Thanks in advance
Use below code for your requirement,
Thank yo,
Amol Salve
Salesforce Developer