I created three formula fields on a custom object. 

1. Formula(Date) references parent objects
2. Formula(Time) references parent objects
3. Formula(DateTime) references formula field 1 & 2.

When I query for these fields using SOQL, field 1 & 2 return their value. Field 3 returns NULL. If I open up the record, there is a value in the field. 

Does anyone know why this is happening or what I can do to fix it? 

I have tried using [`Formula.recalculateFormulas()`](https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_class_System_Formula.htm?search_text=limits). When I performed this on a list i received an 'Unexpected Exception'. 

When I called `recalculateFormulas()` on a single Object in the list, the value was now a valid date time (not null)

See the following code snippet:

```
List<cust)obj__c> listCustomObj = [Select Id, Formula1__c, Formula3__c FROM cust_obj__c];
system.debug(listCustomObj[0].Formula3__c) //null
//List<FormulaRecalcResult> results = Formula.recalculateFormulas(listCustomObj); //throws unexpected exception
listCustomObj[0].recalculateFormulas();
System.debug(listCustomObj[0].Formula3__c) //correct value

```

My questions are: 

1. Why is the initial query returning null instead of the calculated value?
2. Why does the recalculateFormulas() method fail when called on a list?
3. Any way you can recommend (without changing my formula fields) that I can solve this?