Once again thanks. That helps. I cannot use the Advanced Page because some times we get multiple files from the same client or we do some semiautomated editing that breaks...

Sorry, I should have been a little more clear. And thank you very much for answering. Yes you are right you do not always have to reset the columns. I...

A solution I have used in the past is adding in two Derived columns one right after the other. In the first pick apart your date in to a Year...