I have a very simple case that I'm surprised Salesforce migration tool can't deal with.
I have two date fields on Account: Open and Closed.
I then have a formula field that sets a boolean to true if today is between Open and Closed.
These are stored in an unmanaged package.
So far so good. But when I try and destroy these changes (rename package.xml to destructiveChanges.xml, create empty package.xml) I get the following error:
- objects/Account.object (Account.Open_Date__c) -- Error: This custom field is referenced elsewhere in salesforce.com. : Custom Formula Field - Account.Active __c.
But my destructiveChanges should destroy all fields included, the date fields and related formula.
Do I have to bash out staged destructions, ie figure out which fields are formula fields, destroy those, then destroy other fields? These seems horrible and I was hoping the tool would be smart enough to recognise that the destruction is self contained.