I need to do Field History Tracking on BillingCountryCode and BillingPostalCode on Account. I only can chose the field BillingAddress in the Tracking setup. But whereas BillingCountryCode and BillingPostalCode are filled in my data (they are set in Apex code mostly), the compound field BillingAddress is not. So it seems that if there is a change in Country or PostalCode, the field BillingAddress is not affected.
So this query gives me results for BillingPostalCode and BillingCountryCode, but BillingAddress is not filled in any Account:
Select BillingPostalCode, BillingCountryCode, BillingAddress from Account
When I turn on Field History Tracking, and I query this:
SELECT AccountId,Field,Id,NewValue,OldValue FROM AccountHistory
the changed fields "BillingPostalCode" and "BillingCountryCode" show in the AccountHistoryTable, but without a OldValue and also without a NewValue.