Reference Code format not prevailing when using "Concatenate" Advanced Function

Alicia Beltran shared this question 2 years ago
Answered

Using application 8.0.9 version.

Here's the expectation for Year and Month concatenate fields, the format for Month must include a zero:

2020 09

2020 10

2020 11

2020 12

2021 01

2021 02

Using Reference Codes helps to show the Month format as desired, however, when this field is concatenated (using Advanced Function), the format of the reference code is not prevailing:

/73bb2a0c5782f0b0f01d5006cb5469be

Replies (2)

photo
1

I was able to figure this out.

It is required to create an additional Reference Code, using in "Code" the values as the Concatenate function is displaying the data:

/b399a525ec40751bcf81beb5c2dc3165

After using the Concatenate function, just change the format of the field to use above Reference Code.

photo
1

HI Alicia,

Thanks for reaching out with your question. Glad to see you were able to come up with a solution for this! I'll mark this question as Answered, hopefully this info will be useful to someone else in the Community!

Thanks,

Eric

Leave a Comment
 
Attach a file