Ok, I have data in a field called 'Month' that is formatted like this "Jan 2002", "Feb 2002", and so on...
Using a computed item, I want to derive a new field from the 'Month' column called 'Quarter' and I want it formated like "2002 Q1", "2002 Q2", etc.
I have tried to use LTrim, ToQtr and...