Report Builder SSRS

[jeffinperth]

Testing Report Builder, have built a model, and want to extract a date in DDMMYYYY format.
tried to define a formula, if i use
DAY(variable_date) the syntax is fine, but when i do
DAY(variable_date)MONTH(variable_date)YEAR(variable_date)
get the error

The following syntax error occurred: expected end of formula

any ideas?

cheers

Jeff

 

[ablackwe]

Have you tried adding & inbetween each of the functions? i.e. DAY(variable_date) & MONTH(variable_date) & YEAR(variable_date)

Hope this helps
Thanks
Adam