i have month and year in my data separetly. but i want to combined it....
eg : my output will be jan-2010 lik that
thanks in advance
Should be this in your script
Month &'-'& Year as Period
From yout Table;
You need to use Monthname(Datefield) as MonthYear and make new field, also you try Month(Datefield)&'-'&Year(Datefield) as MonthYear
Retrieving data ...