Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Plz find attached, it worked for yr, but how do i split day & month
Thanks
Hi,
I have attached this in previous reply also.
In case you did,t find that, here you go again (Main_Solution.qvw).
Hi,
Even this 1 is corrupted.
Regards
ASHFAQ
Hi,
Please find the attached file, hope it solves your quest.
Alternatively, you can do the same in script
Hi,
I have attached this in previous reply also.
In case you did,t find that, here you go again (Main_Solution.qvw).
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.....