Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
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
regards
Hi Usha,
You need to use Monthname(Datefield) as MonthYear and make new field, also you try Month(Datefield)&'-'&Year(Datefield) as MonthYear
Regards,
Anand
Should be this in your script
Mont,
Year,
Month &'-'& Year as Period
From yout Table;
Hi Usha,
You need to use Monthname(Datefield) as MonthYear and make new field, also you try Month(Datefield)&'-'&Year(Datefield) as MonthYear
Regards,
Anand