Data type conversion Functions

  • 2 May 2022
  • 0 replies
  • 146 views

Userlevel 4
Badge +3
  • Community Manager
  • 41 replies

Having the correct data type is important when working in Pigment. Especially when writing formulas, depending on the syntax of Function, you might need to adjust the data type.  Below is a table letting you know which functions can help you achieve this.

 

 

Original Data type Converted data Type Function used

Date

Number

Integer

DAY

MONTH

WEEKDAY

YEAR 

Date

Dimension

TIMEDIM

Numbers or Integers

Date

DATE

Numbers or Integers

Text

TEXT

Text

Number

Integer

VALUE

Text Dimension  ITEM
Text

Date

DATEVALUE

Dimension Text

Dimension.Name - Reference the Name property of the Dimension

 

 

 


0 replies

Be the first to reply!

Reply