Hi All,
I have a quarter field in data base like 200401 ,200402 like this for 1st quarter & 2nd quarter respectvely .
But I want to show it like "first quarter", "second quarter" instead of 200401,200402 .
(for data ref:you can check go sales package)
How can i do this ?
Thanks in adv!!
Hi,
U want show "first quarter", "second quarter" instead of 200401,200402 .If these are the only values u are getting from database.Then u can create one data item by using case function.
case if(quarter field=200401) then "first quarter" else "second quarter" end.
if u are getting more than two value from dta base for quarter field then u have to edit the case function as folows.
case if(quarter field=200401) then "first quarter", if(quarter field=200402) then "second quarter" if(quarter field=200403) then "third quarter" end.
Regards,
Momin.
Try this
if (substring( cast ([date], varchar(10)),5,6)='01') then
('Quarter 1')
else
if(substring(cast([date], varchar(10)),5,6)='02') then
('Quarter 2')
else
if(substring(cast([date], varchar(10)),5,6)='03') then
('Quarter 3')
else
('Quarter 4')