TIMEDIM function

  • 21 December 2021
  • 0 replies
  • 315 views

Userlevel 3
Badge

 

Description

Converts a date into an item of a list from with the Application’s Calendar.

 

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,31,12), 'Month')

returns "Dec 20", item of the Month list

same dimension as time_dimension

TIMEDIM(DATE(2020,31,12), '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


0 replies

Be the first to reply!

Reply