TIMEDIM function (Time & Date)

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!