DataFunction
View as Markdown
Functions that operate on a property value, for example.
Values
| Name | Number | Description |
|---|
DATA_FUNCTION_NO_OP | 0 | Returns the data without modifying it. |
DATA_FUNCTION_YEAR | 1 | Gets the year of a date or timestamp value (e.g. 2004). |
DATA_FUNCTION_MONTH | 2 | Gets the month of a date or timestamp value (e.g. "02"). |
DATA_FUNCTION_YEAR_AND_MONTH | 3 | Gets the year and month of a date or timestamp value (e.g. "2004-02"). |
DATA_FUNCTION_DATE | 4 | Gets the date part of a date or timestamp value (e.g. 2004-02-15). |
DATA_FUNCTION_DAYS_FROM | 5 | Gets the difference of the current timestamp and a specified date or timestamp value as the number of days (e.g. 8 or -10). |
DATA_FUNCTION_DAYS_TO | 6 | Gets the difference of a specified date or timestamp value and the current timestamp as the number of days (e.g. 10 or -8). |
DATA_FUNCTION_INTEGER_SEGMENT | 7 | Gets the integer segment of a value (an integer number or a real number) based on a defined segment size. |
DATA_FUNCTION_LEFT_CHARACTERS | 8 | Gets a defined amount of left characters from a text or typed value. |
DATA_FUNCTION_INITIAL_CHARACTER_GROUP | 9 | Gets an initial character group from a text or typed value. |
Used in fields
