---
title: "TIMEDIM function (Dimensional)"
slug: "timedim-function-dimensional"
description: "Learn to transform raw dates into structured time data using the TIMEDIM function in Pigment for smarter calendar-based planning."
updated: 2025-10-27T16:51:25Z
published: 2025-10-30T09:30:13Z
---

> ## 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.

# TIMEDIM function (Dimensional)

## Description

Converts a date into an item of a Calendar Dimension.

## Syntax

```plaintext
TIMEDIM(Date, Time Dimension)
```

- `Date` can be stored in a Metric or List Property with the `Date` data type
- `Date` can also be calculated by using the `DATE` function, for example (`DATE(2020, 12, 31)`)
- `Time Dimension` based on the calendar setting for your application; choose one of the following dimensions `Day`, `Week`, `Month`, `Quarter`, `Half`, `Year`

## Return type

same dimension as `Time Dimension`

## Examples

| **Case** | **Results** | **Return Type** |
| --- | --- | --- |
| `TIMEDIM(DATE(2020,12,31), 'Month')` | returns `"Dec 20",` item of the Month list | same dimension as `Time Dimension` |
| `TIMEDIM(DATE(2020,12,31), 'Year')` | if Fiscal Year start in January, returns `"FY20"` | same dimension as `Time Dimension` |
| `TIMEDIM('Employee'.'Start Date', 'Month')` | returns the `Month` period corresponding to each employee `Start Date` | same dimension as `Time Dimension` |
| `TIMEDIM(Quarter.'Start Date',Month)` | returns the first `Month` of a given `Quarter` | Dimension (Month) |

**Excel equivalent**: None

**See also**: [ITEM](/v1/docs/item-function)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!