TIMEDIM function (Dimensional)

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

Description

Converts a date into an item of a Calendar Dimension.

Syntax

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

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