Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

month- year

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

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

2 Replies
Not applicable
Author

Should be this in your script

Mont,

Year,

Month &'-'& Year      as Period

From yout Table;

its_anandrjs

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