Help with Title expression

[Cameron94]

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. 

[random_user_3869]

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

[Cameron94]

Hi thanks for the help, I still get this message 

[random_user_3869 · Accepted solution]

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