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
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)
Hi Zion,
Have a look at the attached application.
Regards
ASHFAQ
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
Hi,
Have a look at my attachment
Regards
ASHFAQ