Skip to main content

Hi all,

My client is filling in the playbook with contract start date and end date.
We’re using the YEAR function to separate the year from these fields.

The issue is that the result comes out with a comma (2,024 instead of 2024), and in the output document we need it displayed without the comma.

I also noticed that this formula can only be applied on a Numeric answer type and not on a Text one, which makes formatting trickier.

Does anyone know how to format the year properly without the comma, or suggest a workaround to achieve a clean output?

Thanks in advance!

My guess is that you the number is affected by the overall number formatting and localization rules.

A quick-and-dirty workaround would be to create a hidden question in the playbook, with conditional answers depending on the previous question with the YEAR function

So it would be something like this

Question 1 (YEAR): 2,024
Then
Question 2 (Year to display - hidden): 2024
This would be a text field rather that numeric so it won’t be affected by localization.

You would put conditional so that when Question 1 = 2,024, then Question 2 = 2024, when Question 1 = 2,025, then question 2 = 2025 and so on for the next few years.

You would then be able to insert this value as a parameter into the Dealroom/Output Document

Terms & ConditionsCookie settingsAccessibility statement