TIMEDIM function

  • 21 December 2021
  • 0 replies
  • 2494 views
Samya Barkaoui
Rank
Userlevel 5
Badge +3

 

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, Month, Quarter, 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

 

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!

 

Samya
This topic has been closed for comments

Ask your question here!

Terms & ConditionsCookie settings