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