How do i split 3 segment on a listbox into 3 different listbox

[Anonymous]

Plz find attached, it worked for yr, but how do i split day & month 

Thanks

[tresB]

Day(list box expression) : =Aggr(Day(Date#(Left(C.Base,11), 'DD MMM YYYY')),C.Base)

Month(list box expression) : =Aggr(Month(Date#(Left(C.Base,11), 'DD MMM YYYY')),C.Base)

[ashfaq_haseeb]

Hi Zion,

Have a look at the attached application.

Regards

ASHFAQ

[tresB]

Just remove the Aggr from the expression part and try like:

Day(Date#(Left(C.Base,11), 'DD MMM YYYY')) as Day

Month(Date#(Left(C.Base,11), 'DD MMM YYYY')) as Month

[ashfaq_haseeb]

Hi,

Have a look at my attachment

Regards

ASHFAQ