Replacing text with nothing

[Chris Tracey]

Hello

I have a date in the format 27 May 2017. I want to create a string which removes the spaces i.e 27May2017.

To do this I have set up a calculation field (called datenospace) with the following formula

replace(formatdate(#{datevar}),' ','')

where datevar is the input date variable.

When I do this I get a message in the datenospace variable which says:

"One string argument and two character arguments are required"

Now the formula works if I'm trying to replace the space with another character rather than a null. For example if I put an asterix in between the final two single quotes then it works fine.Therefore I'm guessing my problem is the two single quotes at the end of the formula, but I can't work out the correct way of doing what I need to do.

Grateful for you help as always.

Thanks

Chris