how to concatenate year and month

[#1]

HI friends,

could you help me on this.

[MK_QSL]

If you need output like YYYYMM use as below while creating calender.

Date(MonthStart(DateField),'YYYYMM') as YearMonth

If you want MonthYear i.e. MMYYYY use as below

Date(MonthStart(DateField),'MMYYYY') as YearMonth

If you want YYYY-MMM change accordingly..

[vinieme12]

if your Year and Month fields are separate then

Num(Year&Num(Month,'00')) as YearMonth 

this will give you values like 201601,201602 and so on

[surendraj]

If you have the day,month,year in seperate fields,you can concatinate by

date(makedate(year,month,day),'YYYY/MM') as year-month

[#5]

Hi ,

Thanks  for your posting,

i have been used the below date(floor(datefield),'mm-yy')  as as_yr_month

it is worked fine  fine  as per my requirnent.