Quote Originally Posted by T4FF
So first question, what is dateapp2? A custom field? How do I find out what it is doing? i.e. is it manipulating the dateapp field at all?
With the PT active ...

Given the external source I would say the first thing to do would be to view the SQL to see if the dateapp2 field is created in the query.

You can do this via the PT Options tab on the Ribbon -> Change Data Source -> Connection Properties -> Definition ... see Command Text box for SQL.

If the field is not created in the query then to view the Calculated Field (again via Options tab in the Ribbon) Formulas -> List Formulas or use Calculated Field and select dateapp2 from the dropdown list.

Quote Originally Posted by T4FF
secondly, where are the custom values coming from?
This is obviously going to be partly dependent upon how dateapp2 is being generated but in general terms PTs will by default cache prior member values.
In 2007 you can disable this via PT Options Tab -> Options -> Data tab -> Number of Items to Retain per Field -> None.

You should then find when you next refresh the PT cache the legacy items will have been purged.