For some reason I can’t reply on this post… anyway
Sorry to say guys, none of the suggestions have worked. (BTW Steve, I believe you left out a single quote in your expression.) I would rather not post the actual file due to size and the fact that it is our company's financial data. However, I would really like to know what is going on.
As far as a possible bug goes, I'm running v10.00.8715.5 IR 64-bit Edition (x64)
I have the dates formatted in the table load as follows:
and the initial load as
I changed the initial load to the following, but it had no effect
However, I believe I encountered a bug with a similar model of mine, where I could not get the syntax to work out (and I spent days and involved an external consultant who couldn't figure out the issue). So my rather ugly get out was the below formula (only use this as a last resort as I'm sure the performance is far from optimal).