Pigment AI Agents are here! Starting today, we’re launching new AI Agents and updating our documentation for them. Some pages may look different or redirect to new resources. Send us feedback through "Was this article helpful?" at the foot of the page

TIMEDIM function (Time & Date)

  • Updated on Oct 30, 2025
  • Published on Aug 22, 2025
  • 1 minute(s) read
Prev Next

Description

Converts a date into an Item of a Calendar Dimension.

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

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!

Related articles