bizproducer
Programmer
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 if statements like this:
if (Request.Month == 'Jan 2002') {'2002 Q1'}
Maybe I just need a lesson in syntax? Please help!
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 if statements like this:
if (Request.Month == 'Jan 2002') {'2002 Q1'}
Maybe I just need a lesson in syntax? Please help!