FTMVT returns text values from a 15 minute variable. NOTE: This function has been replaced by DDVT and is only documented here for older reports that may still use the FTMVT function.
SYNTAX:
FTMVT(VarNum,Offset/Date, Decimal_Places)
VarNum: The variable number to get the value for.
Offset/Date:If the field is numeric it is assumed to be the offset and is defined as the offset (number of slots for the variable type) from the start date of the report. For example, if the start date is 1/1/2000 and the offset is 2 the value for the 2nd data slot will be returned. I.E. for a 15 minute variable the value for the 12:15 AM to 12:30AM slot will be returned. If the field is a date/time in quotes or a cell reference to a cell containing a date/time the value for the slot specified by the date/time will be returned.
Decimal_Places: Sets the number of decimal places to return result in.
NOTES:
WARNING: Function is still supported but has been replaced by DDVT. Support for this function may be ended. Use at your own risk.