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 |