Quarter to Text?

Hello Community,

How can i go from the line item Quarter ( Quarter ) to Quarter ( Text )

example :

Q3 (Quarter format) to Q3 (Text format)

Thank you

Accepted answers

1636583

Hi @ILYAS

from Month to text, it will give you what you are seeing like Jan 24(Text), if you want digit then you need to extract month and year separately and concat those two.

Dikshant

NAME('Month (month)') will give Jan 24 in Text format. If you need the month in 012024 (text) format. Use this formula: (IF MONTH('Month (month)') < 10 THEN "0" & TEXT(MONTH('Month (month)')) ELSE TEXT(MONTH('Month (month)'))) & TEXT(YEAR('Month (month)'))

SriNitya

@ILYAS
Convert between data types | Anapedia
Is the go to article which gives the overview of the conversion functions and then by going through each function helps to solve the conversion issues.

All comments

Dikshant

Does this help?

Dikshant

For more data conversions like these, refer this article.

https://help.anaplan.com/convert-between-data-types-1a1ac604-62d2-4288-abaa-55fd8e2ee8e2

ILYAS

do i have to do the same thing if for example i want to go from
Jan 24 (month ) to 012024 ( Text ) ?

1636583

Hi @ILYAS

from Month to text, it will give you what you are seeing like Jan 24(Text), if you want digit then you need to extract month and year separately and concat those two.

Dikshant

SriNitya

@ILYAS
Convert between data types | Anapedia
Is the go to article which gives the overview of the conversion functions and then by going through each function helps to solve the conversion issues.

Quick Links

Can you help?

Unanswered questions

ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…