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

[ashfaq_haseeb]

Hi,

Even this 1 is corrupted.

Regards

ASHFAQ

[#3]

Hi,

Please find the attached file, hope it solves your quest.

Alternatively, you can do the same in script

[#4 · Accepted solution]

Hi,

I have attached this in previous reply also.

In case you did,t find that, here you go again (Main_Solution.qvw).

[#5]

Hi,

For that, just replace the month expression by

=if(mid([Base Date - Base Date Level 01 (Text)],4,2)='01',dual('Jan',1),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='02',dual('Feb',2),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='03',dual('Mar',3),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='04',dual('Apr',4),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='05',dual('May',5),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='06',dual('Jun',6),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='07',dual('Jul',7),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='08',dual('Aug',8),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='09',dual('Sep',9),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='10',dual('Oct',10),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='11',dual('Nov',11),

if(mid([Base Date - Base Date Level 01 (Text)],4,2)='12',dual('Dec',12),

))))))))))))

Find the attached file.....