FluentPro Help Center

What do you need help with?

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.


    Functions List

    Conversion

    Formula
    Description
    Asc( string )
    Converts a value to Integer
    CBool( expression ) Converts a value to Boolean
    CByte( expression )
    Converts a value to Byte
    CCur( expression )
    Converts a value to Decimal (currency format, 2 digits)
    CDate( expression )
    Converts a value to DateTime
    CDbl( expression )
    Converts a value to Double
    CDec( expression )
    Converts a value to Decimal
    Chr( charcode )
    Converts a value to a Unicode character
    CInt( expression )
    Converts a value to Short Integer
    CLng( expression )
    Converts a value to Integer
    CSgn( expression )
    Converts a value to Single
    CStr( expression )
    Converts a value to String
    CVar ( expression )
    Converts a value to Double if possible, otherwise – to String
    DateSerial( year, month, day )
    Returns a Date value representing a specified year, month, and day, with the time information set to midnight (00:00:00)
    DateValue( date )
    Returns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00)
    Day( date )
    Returns the day component of the date value

    FormatCurrency( expression [, numDigitsAfterDecimal [, includeLeadingDigit [, useParensForNegativeNumbers [, groupDigits]]]] )
    Returns an expression formatted as a currency value using the currency symbol defined in the system control panel. http://msdn.microsoft.com/en-us/library/3352e6f5(v=vs.90).aspx
    FormatDateTime( date [, namedFormat] )
    Returns a string expression representing a date/time value. http://msdn.microsoft.com/en-us/library/a912f2a0(v=vs.90).aspx
    FormatNumber( expression [, numDigitsAfterDecimal [, includeLeadingDigit [, useParensForNegativeNumbers [, groupDigits]]]] )
    Returns an expression formatted as a number.\\http://msdn.microsoft.com/en-us/library/xfta99yt(v=vs.90).aspx
    FormatPercent( expression [, numDigitsAfterDecimal [, includeLeadingDigit [, useParensForNegativeNumbers [, groupDigits]]]] )
    Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character. http://msdn.microsoft.com/en-us/library/8zh1kxd7(v=vs.90).aspx
    Hex( number )
    Converts a value to an Int64
    Hour( time )
    Returns the hour component of the date value
    Minute( time ) Returns the minute component of the date value
    Month( date )
    Returns the month component of the date value
    Oct( number )
    Converts a value to an Integer in a base 8
    ProjDateConv( expression [, dateformat] )
    Converts a value to a date. http://office.microsoft.com/en-us/project-help/project-functions-for-custom-fields-HP010080956.aspx
    ProjDateValue( expression
    Returns the date value of an expression. http://office.microsoft.com/en-us/project-help/project-functions-for-custom-fields-HP010080956.aspx
    ProjDurConv( expression [, durationUnits] )
    Converts an expression to a duration value in the specified units. http://office.microsoft.com/en-us/project-help/project-functions-for-custom-fields-HP010080956.aspx
    ProjDurValue( expression )
    Returns the number of minutes in a duration. http://office.microsoft.com/en-us/project-help/project-functions-for-custom-fields-HP010080956.aspx
    Second( time ) Returns the second component of the date value
    StrComp( string1, string2 [, compare] )
    Returns a string converted as specified. http://msdn.microsoft.com/en-us/library/cd7w43ec(v=vs.90).aspx
    Str( number )
    Returns a String representation of a number. http://msdn.microsoft.com/en-us/library/4y6a1sx7(v=vs.90).aspx
    TimeSerial( hour, minute, second )
    Returns a Date value representing a specified hour, minute, and second, with the date information set relative to January 1 of the year 1. http://msdn.microsoft.com/en-us/library/ws25fd2z(v=vs.90).aspx
    TimeValue( time ) Returns a Date value containing the time information represented by a string, with the date information set to January 1 of the year 1. http://msdn.microsoft.com/en-us/library/hz2ahtzs(v=vs.90).aspx
    Val( string ) Returns the numbers contained in a string as a numeric value of appropriate type. http://msdn.microsoft.com/en-us/library/k7beh1x9(v=vs.90).aspx
    Weekday( date [, firstdayofweek] ) Returns an Integer value containing a number representing the day of the week. http://msdn.microsoft.com/en-us/library/82yfs2zh(v=vs.90).aspx
    Weekday( date [, firstdayofweek] ) Returns an Integer value from 1 through 9999 representing the year. http://msdn.microsoft.com/en-us/library/88k2aec8(v=vs.90).aspx

    Domain

    Formula
    Description
    DAvg( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and calculates the average of object values. Can accept filter criteria
    DCount( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the number of objects. Can accept filter criteria
    DFirst( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the first object. Can accept filter criteria and sort order
    DLast( fieldName, domain [, criteria] ) Executes a query against the specified domain, selects the specified field and returns the last object. Can accept filter criteria and sort order
    DLookup( fieldName, domain [, criteria] )
    Executes a query against the specified domain, gets a single instance and returns the specified instance field value. Can accept filter criteria
    DMax( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the maximum of object values. Can accept filter criteria
    DMin( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the maximum of object values. Can accept filter criteria
    DStdDev( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the standard deviation of object values. Can accept filter criteria
    DStdDevP( fieldName, domain [, criteria] ) Executes a query against the specified domain, selects the specified field and returns the population variance of object values. Can accept filter criteria
    DSum( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the sum of object values. Can accept filter criteria
    DVar( fieldName, domain [, criteria] )
    Executes a query against the specified domain, selects the specified field and returns the variance of object values. Can accept filter criteria
    DVarP( fieldName, domain [, criteria] )
    See DStdDevP function

    External Data

    Formula
    Description
    FormatHeaders( name1, value1 [, name2, value2, …] )
    Formats headers (name-value pairs) into a String for a web service call
    HttpEncode( name1, value1 [, name2, value2, …] )
    Takes name-value pairs and creates a HTML-encoded String
    ParseJSON( json, expression )
    Returns an object value from json input by given expression
    ParseXML( xml, xpath )
    Returns an object value from xml input by given xpath expression
    WSSDeliverablesQuery( expression [, filter [, order]] )
    Queries SharePoint site Deliverables list with given SQL-like expression. Can accept WHERE-like filter and ORDERBY-like order expressions
    WSSIssuesQuery( expression [, filter [, order]] )
    Queries SharePoint site Issues list with given SQL-like expression. Can accept WHERE-like filter and ORDERBY-like order expressions
    WSSRisksQuery( expression [, filter [, order]] )
    Queries SharePoint site Risks list with given SQL-like expression. Can accept WHERE-like filter and ORDERBY-like order expressions
    SqlQuery( query, connectionString )
    Executes a SQL query with provided connectionString. Returns the first scalar object value
    SpListQuery( listName, field [, filter[, order[, siteUrl]]] )
    Queries a SharePoint list by specified listname, returns the first field’s value. Accepts SQL-like select expressions Defaults: filter – empty string. order – empty string. siteUrl – current SharePoint site URL
    WebServiceCall( url [, requestType [, requestData [, requestContentType [, headers]]]] )
    Executes an HTTP call to the specified url. Can accept request type, pass request data, specify request content type and pass headers. Defaults: requestType = Get requestData = empty string requestContentType = text/html; charset=utf-8 headers = empty string (no headers overridden)

    General

    Formula
    Description
    Choose( index, expression1, expression2, … )
    Selects and calculates the expression based on the index
    IIf( expression, truepart, falsepart )
    The conditional IF function. Select truepart if expression is TRUE, otherwise falsepart
    IsNull( expression )
    Returns TRUE if the expression is NULL
    IsNumeric( expression )
    Returns TRUE if the expression is numeric
    Switch( expression1, value1 [, expression2, value2 [, …]] ) The Switch function

    Generation

    Formula
    Description
    NewGuid( )
    Generates new GUID value
    NewId( [startNumber [, step [, scope]]] )
    Generates a sequential numeric ID starting from startNumber, with step and within the scope. Defaults: startnumber = 1 step = 1 scope = empty string

    Mathematical

    Formula
    Description
    Abs( number )
    Returns an absolute value of the specified number
    Atn( number ) Returns the angle whose tangent is the specified number
    Cos( number )
    Returns the cosine of the specified angle
    Exp( number )
    Returns e raised to the specified power
    Fix( number )
    If the specified number is negative, returns the smallest integral value that is greater than or equal to the specified number. Otherwise, returns the largest integer less than or equal to the specified number
    Int( number ) See Fix function
    Log( number )
    Returns the natural (base e) logarithm of a specified number
    Rnd( number )
    Generates a random Integer value based on the seed number specified
    Round( number [, numdecimalplaces] ) Rounds a double-precision floating-point value to a specified number of fractional digits. Defaults: numdecimalplaces = 0
    Sgn( number ) Returns a value indicating the sign of a double-precision floating-point number
    Sin( number ) Returns the sine of the specified angle
    Sqr( number ) Returns the square root of a specified number
    Tan( number ) Returns the tangent of the specified angle

    Text

    Formula
    Description
    Format( expression, format )
    Returns a string formatted according to instructions contained in a format String expression. http://msdn.microsoft.com/en-us/library/59bz1f0h(v=vs.90).aspx
    InStr( [start, ] string1, string2 [, compare] )
    Returns an integer specifying the start position of the first occurrence of one string within another. http://msdn.microsoft.com/en-us/library/8460tsh1(v=vs.90).aspx
    InStrRev( stringcheck, stringmatch [, start [, compare]] ) Returns the position of the first occurrence of one string within another, starting from the right side of the string. http://msdn.microsoft.com/en-us/library/t2ekk41a(v=vs.90).aspx
    LCase( string )
    Returns a string or character converted to lowercase. http://msdn.microsoft.com/en-us/library/7789633z(v=vs.90).aspx
    Left( string, length )
    Returns a string that contains a specified number of characters from the left side of a string. http://msdn.microsoft.com/en-us/library/y050k1wb(v=vs.90).aspx
    Len( string ) Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable. http://msdn.microsoft.com/en-us/library/dxsw58z6(v=vs.90).aspx
    LTrim( string )
    Returns a string containing a copy of a specified string with no leading spaces. http://msdn.microsoft.com/en-us/library/h9wz3dez(v=vs.90).aspx
    Mid( string, start [, length] ) Returns a string containing a specified number of characters from a string. http://msdn.microsoft.com/en-us/library/05e63829(v=vs.90).aspx
    Replace( expression, find, replace [, start [, count [, compare]]] )
    Returns a string in which a specified substring has been replaced with another substring a specified number of times. http://msdn.microsoft.com/en-us/library/bt3szac5(v=vs.90).aspx
    Right( string, length )
    Returns a string containing a specified number of characters from the right side of a string. http://msdn.microsoft.com/en-us/library/dxs6hz0a(v=vs.90).aspx
    RTrim( string )
    Returns a string containing a specified number of characters from the right side of a string. http://msdn.microsoft.com/en-us/library/dxs6hz0a(v=vs.90).aspx 
    Space( number )
    Returns a string consisting of the specified number of spaces. http://msdn.microsoft.com/en-us/library/k6ethaxs(v=vs.90).aspx
    String( number, character )
    Initializes a new instance of the String class to the value indicated by a specified Unicode character repeated a specified number of times.
    StrReverse( expression )
    Returns a string in which the character order of a specified string is reversed. http://msdn.microsoft.com/en-us/library/e462ax87(v=vs.90).aspx
    Trim( string )
    Returns a string that contains a copy of a specified string without leading or trailing spaces. http://msdn.microsoft.com/en-us/library/h9wz3dez(v=vs.90).aspx
    UCase( string )
    Returns a string or character containing the specified string converted to uppercase. http://msdn.microsoft.com/en-us/library/53e2ew8a(v=vs.90).aspx

    TimeDate

    Formula
    Description
    DateAdd( interval, number, date )
    Returns a Date value containing a date and time value to which a specified time interval has been added. http://msdn.microsoft.com/en-us/library/hcxe65wz(v=vs.90).aspx
    DateDiff( interval, date1, date2 [, firstdayofweek [, firstweekofyear]] ) Returns a Long value specifying the number of time intervals between two Date values. http://msdn.microsoft.com/en-us/library/b5xbyt6f(v=vs.90).aspx

    Date( )
    Returns the date component of current date
    DatePart( interval, date [, firstdayofweek [, firstweekofyear]] ) Returns an Integer value containing the specified component of a given Date value. http://msdn.microsoft.com/en-us/library/20ee97hz(v=vs.90).aspx
    IsDate( expression ) Returns a Boolean value indicating whether an expression represents a valid Date value. http://msdn.microsoft.com/en-us/library/00wf8zk9(v=vs.90).aspx
    MonthName( month [, abbreviate] )v
    Returns a String value containing the name of the specified month. http://msdn.microsoft.com/en-us/library/zxbsw165(v=vs.90).aspx
    Now( )
    Gets a DateTime object that is set to the current date and time on this computer, expressed as the local time
    Time( )
    Gets the time of day for current date
    Timer( ) The total number of seconds for current date
    WeekdayName( weekday [, abbreviate [, firstdayofweek]] ) Returns a String value containing the name of the specified weekday. http://msdn.microsoft.com/en-us/library/t8dc1aee(v=vs.90).aspx 

    Was this article helpful?

    Table of contents

      Still can't find what you're looking for?

      Contact Support
      Back To Top