Which expression will generate the correct string?

In a Fusion scenario, a new project in Workfront will trigger the creation of a new project in ServiceNow. The name of the project in ServiceNow will be constructed in the following format: Two Digit Year – Reference Number – Project Name.

Which expression will generate the correct string?
A . formatDate(now;YY) – referenceNumber – name
B . join(formatDate(now;YY) – referenceNumber – name)
C . concat(formatDate(now;YY) – referenceNumber – name)

View Answer

Answer: C

Explanation:

Understanding the Requirement:

The desired output format for the project name in ServiceNow is:

Two-Digit Year – Reference Number – Project Name

This requires dynamically constructing a string by combining:

The current year in a two-digit format.

The referenceNumber (a variable or input).

The name (a variable or input, likely the project name).

Why Option C is Correct:

The concat function combines multiple strings into a single string.

Expression:

concat(formatDate(now;YY), " – ", referenceNumber, " – ", name)

This ensures proper formatting with hyphens and spaces between the elements.

Breaking Down the Components:

formatDate(now;YY): Retrieves the current year in a two-digit format (e.g., "23" for 2023).

" – ": Adds the required separator.

referenceNumber: Dynamically adds the reference number.

name: Dynamically adds the project name.

Why the Other Options are Incorrect:

Option A ("formatDate(now;YY) – referenceNumber – name"):

This is not valid because it does not explicitly use a string concatenation function.

Option B ("join(formatDate(now;YY) – referenceNumber – name"):

The join function is used for concatenating elements of an array, not individual strings. Since the inputs are not in an array, this function will not work.

How This Solves the Problem:

The concat function correctly constructs the string with the desired format, dynamically generating the project name for ServiceNow based on the given inputs. Reference and Supporting Documentation:

Adobe Workfront Fusion Functions Documentation

Workfront Community: Using the concat Function