Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression :-
='P&L Report (S$K)' & Chr(10) & date(date#(Year(Today())-3,'YYYY'),'YYYY') & SOURCE & '
Will display as :-
P&L Report (S$K)2014TDSS
i wish it display as :-
P&L Report (S$K) 2014 TDSS
Paul
try this?
= 'P&L Report (S$K)' & Chr(32) & date(date#(Year(Today())-3,'YYYY'),'YYYY') & Chr(32) & SOURCE
I would think just adding spaces in the string would work:
='P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY')&' 'SOURCE
Why are you using the Chr(10) and why is there a single quote at the end?
try this?
= 'P&L Report (S$K)' & Chr(32) & date(date#(Year(Today())-3,'YYYY'),'YYYY') & Chr(32) & SOURCE
Hi Vish
Thank you it work fine.
Paul
Yes it does work. Just one & is missing in your expression just before SOURCE.
= 'P&L Report (S$K) '& date(date#(Year(Today())-3,'YYYY'),'YYYY') & ' ' & SOURCE