FORMAT

This function will format the given value into either a CURRENCY or DATE/TIME format.

FORMAT(Type,Value,DateFormat)

Parameters

Type
            CURRENCY = Format value into currency
            DATE = Format value into date.

Value
            The value to format.

DateFormat
            0 = General Date
            1 = Long Date
            2 = Short Date
            3 = Long Time
            4 = Short Time