Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to show as follows:
Data as of 11 oct 2020 as a title for a sheet for example
I have managed to get this to work but when adding 'Data As of' it doesn't work.
Expression I am using: ('Data as of'(vLoadDate,'DD.MMM.YY'))
I think I am doing something very small but cant figure it out.
Thanks.
Oh my bad i will correct what i said:
Basically if your output is 'Data as of 11 oct 2020'
and the output of your variable 'vLoadDate' is '11 oct 2020'
you should write it like this:
Option 1:
= 'Data as of'&chr(32)&'$(vLoadDate)' OR 'Data as of'&chr(32)&$(vLoadDate)
for your info chr(32) = space
and you should'nt add 'DD.MMM.YY' after your date variable as you already formatted it
Hello,
Instead of ('Data as of'(vLoadDate,'DD.MMM.YY'))
you should write
('Data as of'&(vLoadDate,'DD.MMM.YY'))
Between the string characters and the variable you forgot to add '&'.
The same goes for set analysis.
Hope it helps
Hi thanks for the help, I still get this message
Oh my bad i will correct what i said:
Basically if your output is 'Data as of 11 oct 2020'
and the output of your variable 'vLoadDate' is '11 oct 2020'
you should write it like this:
Option 1:
= 'Data as of'&chr(32)&'$(vLoadDate)' OR 'Data as of'&chr(32)&$(vLoadDate)
for your info chr(32) = space
and you should'nt add 'DD.MMM.YY' after your date variable as you already formatted it