Data type conversion Functions

  • 2 May 2022
  • 0 replies
  • 3059 views

Userlevel 7
Badge +13

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, Numbers, or Integers Dimension  ITEM
Text

Date

DATEVALUE

Dimension Text

Dimension.Name - Reference the Name property of the Dimension

 

 

 


This topic has been closed for comments