---
title: "Guide to Data Type Conversion Functions in Pigment"
slug: "data-type-conversion-functions"
description: "Convert text, numbers, dates, and booleans easily using Pigment’s powerful data type conversion functions."
updated: 2025-05-29T11:20:36Z
published: 2025-08-22T12:00:18Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data type conversion Functions

Having the correct data type is important when working in Pigment. Especially when writing formulas, depending on the syntax of Function, you might need to adjust the data type. Below is a table letting you know which functions can help you achieve this.

| Original Data type | Converted data Type | Function used |
| --- | --- | --- |
| **Date** | Number Integer | [DAY](/v1/docs/day-function) [MONTH](/v1/docs/month-function) [WEEKDAY](/v1/docs/weekday-function) [YEAR](/v1/docs/year-function) |
| **Date** | Dimension | [TIMEDIM](/v1/docs/timedim-function) |
| **Numbers or Integers** | Date | [DATE](/v1/docs/date-function) |
| **Numbers or Integers** | Text | [TEXT](/v1/docs/text-function) |
| **Text** | Number Integer | [VALUE](/v1/docs/value-function) |
| **Text, Numbers, or Integers** | Dimension | [ITEM](/v1/docs/item-function) |
| **Text** | Date | [DATEVALUE](/v1/docs/datevalue-function) |
| **Dimension** | Text | Dimension.Name - Reference the Name property of the Dimension |