Calculating the year in a flow without it appearing as 2,021

Question

I've created a flow to automatically create a 'renewal' record on a custom object. The name of the current record ends in the year, but the automatically created record name should have next year at the end instead (and so on for future).

I've created a field to say the year, and pulled this into the flow with a formula to add 1, so 2021 becomes 2022. All fine, but when I pull this into the record name, it formats as a number so I have 'Record name 2,021'. If I make the year field text, I can't use it in the formula to add a year.

How do I get rid of the number format so my record name ends in 2021 with out the ,?

Tony Trinh · Accepted Answer

Hi Sara,

Of course you can use it in the formula to add the year. You just convert it back to text when adding the year. You probably have something like YEAR(DateField) + 1. All you gotta do is wrap it in TEXT()

TEXT(YEAR(DateField) + 1)

Calculating the year in a flow without it appearing as 2,021

Data Management

Aprendizaje relacionado

Más ayuda