Trying to remove the dashes in the date

[learn2]

What is your goal?

Trying to remove the dashes in the date

What is the problem?

The date is not recognised by the calendar

What have you tried so far?

Discovered that the replace function will do it but I don’t know how to use it

Screenshots: scenario setup, module configuration, errors

[AnthonyatXRAY]

You are correct in using the replace() function, you just have to nest it in a text field. The syntax to use is: replace(yourDateField; “-”; “”)

This removes every dash from the string. If Zoho chokes on the space or +0000 offset, chain replace() calls or run it through formatDate() to control the output pattern to the format you need.

Better to try the formatDate option as it is more reliable than replacing the string, it lets you match Zoho’s expected format better. I use it all the time.

[learn2]

@AnthonyatXRAY

formatDate option

Where do I find this?

[mszymkowiak]

Hello,

@learn2

Where do I find this?

Here:

If your date is not date but sting you should also use nested parseDate in your function.

Example for string 2026-06-16

{{formatDate(parseDate("2026-06-16"; "YYYY-MM-DD"); "DDMMYYYY")}}

parseDate parses string of 2026-06-16 (YYYY-MM-DD) to date.
formatDate formats it to desired format- in your dace DDMMYYYY.

You can learn more here:

Date and time functions - Help Center

And here:

Tokens for date/time formatting - Help Center