FluentPro Help Center

What do you need help with?

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

    Back To Top