• Jennifer Johnson 8
  • NEWBIE
  • 10 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 6
    Replies
I have the below formula that has been working fine, until this month...

DATE( 
year(End_of_Mth__c) 
+ floor((month(End_of_Mth__c) + 4)/12) + if(and(month(End_of_Mth__c)=12,4>=12),-1,0) 

if( mod( month(End_of_Mth__c) + 4 , 12 ) = 0, 12 , mod( month(End_of_Mth__c) + 4 , 12 )) 

min( 
day(End_of_Mth__c), 
case( 
max( mod( month(End_of_Mth__c) + 4 , 12 ) , 1), 
9,30, 
4,30, 
6,30, 
11,30, 
2,28, 
31 


)

when my End of Mth date is 8/31/2014 the date being returned is 12/31/2015 instead of 12/31/2016.  All other months are working fine (before and after 8/31/2014) - I can't figure out why just that date is messing up?

Thank you!!
Currently Exact Target adds what we call "Individual Email Results" (a custom object in our SF).  I want these to stop.  When my email marketing manager asked ET, they said they couldn't.  That we'd have to turn off ALL integration, which is not an option.  Seems like this shouldn't be a big deal - but I am in way over my head with this stuff.  
Can I just inactivate the custom object in SF??  These are using up all our storage and going forward we are going to get this data from Pardot.

Any help would be greatly appriciated!!
I have the below formula that has been working fine, until this month...

DATE( 
year(End_of_Mth__c) 
+ floor((month(End_of_Mth__c) + 4)/12) + if(and(month(End_of_Mth__c)=12,4>=12),-1,0) 

if( mod( month(End_of_Mth__c) + 4 , 12 ) = 0, 12 , mod( month(End_of_Mth__c) + 4 , 12 )) 

min( 
day(End_of_Mth__c), 
case( 
max( mod( month(End_of_Mth__c) + 4 , 12 ) , 1), 
9,30, 
4,30, 
6,30, 
11,30, 
2,28, 
31 


)

when my End of Mth date is 8/31/2014 the date being returned is 12/31/2015 instead of 12/31/2016.  All other months are working fine (before and after 8/31/2014) - I can't figure out why just that date is messing up?

Thank you!!
Currently Exact Target adds what we call "Individual Email Results" (a custom object in our SF).  I want these to stop.  When my email marketing manager asked ET, they said they couldn't.  That we'd have to turn off ALL integration, which is not an option.  Seems like this shouldn't be a big deal - but I am in way over my head with this stuff.  
Can I just inactivate the custom object in SF??  These are using up all our storage and going forward we are going to get this data from Pardot.

Any help would be greatly appriciated!!