Functions that operate on a property value.
Member | Value | Description |
---|---|---|
MFDataFunctionDate | 4 | Gets the date part of a date or timestamp value (e.g., 2004-02-15). |
MFDataFunctionDaysFrom | 5 | Gets the difference between the current timestamp and a specified date or timestamp value as the number of days (e.g., 8 or -10). |
MFDataFunctionDaysTo | 6 | Gets the difference between a specified date or timestamp value and the current timestamp as the number of days (e.g., 10 or -8). |
MFDataFunctionInitialCharGroup | 9 | Gets an initial character group from text or a typed value. |
MFDataFunctionIntegerSegment | 7 | Gets the integer segment of a value (an integer number or a real number) based on a defined segment size. |
MFDataFunctionLeftChars | 8 | Gets a defined number of left characters from text or a typed value. |
MFDataFunctionMonth | 2 | Gets the month of a date or timestamp value (e.g., 02). |
MFDataFunctionNoOp | 0 | Returns the data without modifying it. |
MFDataFunctionYear | 1 | Gets the year of a date or timestamp value (e.g., 2004). |
MFDataFunctionYearAndMonth | 3 | Gets the year and month of a date or timestamp value (e.g., 2004-02). |