---
title: "Use the TIMEDIM Function to Transform Dates into Calendar Data"
slug: "timedim-function-timedate"
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:49:44Z
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 (Time & Date)

## Description

Converts a date into an Item of a Calendar Dimension.

```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`

## See also

**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!