List box Expression picking up extra value

[onetwothree123]

I have following expression in my list box and it's giving me a extra value as wk.

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week

Not able to figure out how to get rid off it.

See attachemnt for Listbox and expression.

[swarup_malli]

AJ,

Try this,

if(len(MMMYY_Week)>=8,

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week))

or  

if(len(

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week)) >=8,

Date([Date_Field],'MMMYY') &' wk'& ceil(([Date_Field]-floor(WeekEnd(MonthStart([Date_Field]),-1,0)))/7) as MMMYY_Week))

Regards

Swarup

[onetwothree123]

Thanks Swarup