Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks Swarup