title	description	services	documentationcenter	author	manager	ms.reviewer	ms.service	ms.workload	ms.tgt_pltfrm	ms.devlang	ms.topic	ms.date	ms.author
Expression and functions in Azure Data Factory \| Microsoft Docs	This article provides information about expressions and functions that you can use in creating data factory entities.	data-factory		sharonlo101	craigg	douglasl	data-factory	data-services	na	na	conceptual	01/10/2018	shlo

Expressions and functions in Azure Data Factory

[!div class="op_single_selector" title1="Select the version of Data Factory service you are using:"]

Version 1

Current version

This article provides details about expressions and functions supported by Azure Data Factory.

Introduction

JSON values in the definition can be literal or expressions that are evaluated at runtime. For example:

"name": "value"

(or)

"name": "@pipeline().parameters.password"

Expressions

Expressions can appear anywhere in a JSON string value and always result in another JSON value. If a JSON value is an expression, the body of the expression is extracted by removing the at-sign (@). If a literal string is needed that starts with @, it must be escaped by using @@. The following examples show how expressions are evaluated.

JSON value	Result
"parameters"	The characters 'parameters' are returned.
"parameters[1]"	The characters 'parameters[1]' are returned.
"@@"	A 1 character string that contains '@' is returned.
" @"	A 2 character string that contains ' @' is returned.

Expressions can also appear inside strings, using a feature called string interpolation where expressions are wrapped in @{ ... }. For example: "name" : "First Name: @{pipeline().parameters.firstName} Last Name: @{pipeline().parameters.lastName}"

Using string interpolation, the result is always a string. Say I have defined myNumber as 42 and myString as foo:

JSON value	Result
"@pipeline().parameters.myString"	Returns `foo` as a string.
"@{pipeline().parameters.myString}"	Returns `foo` as a string.
"@pipeline().parameters.myNumber"	Returns `42` as a number.
"@{pipeline().parameters.myNumber}"	Returns `42` as a string.
"Answer is: @{pipeline().parameters.myNumber}"	Returns the string `Answer is: 42`.
"@concat('Answer is: ', string(pipeline().parameters.myNumber))"	Returns the string `Answer is: 42`
"Answer is: @@{pipeline().parameters.myNumber}"	Returns the string `Answer is: @{pipeline().parameters.myNumber}`.

Examples

A dataset with a parameter

In the following example, the BlobDataset takes a parameter named path. Its value is used to set a value for the folderPath property by using the following expressions: @{dataset().path}.

{
    "name": "BlobDataset",
    "properties": {
        "type": "AzureBlob",
        "typeProperties": {
            "folderPath": "@dataset().path"
        },
        "linkedServiceName": {
            "referenceName": "AzureStorageLinkedService",
            "type": "LinkedServiceReference"
        },
        "parameters": {
            "path": {
                "type": "String"
            }
        }
    }
}

A pipeline with a parameter

In the following example, the pipeline takes inputPath and outputPath parameters. The path for the parameterized blob dataset is set by using values of these parameters. The syntax used here is: pipeline().parameters.parametername.

{
    "name": "Adfv2QuickStartPipeline",
    "properties": {
        "activities": [
            {
                "name": "CopyFromBlobToBlob",
                "type": "Copy",
                "inputs": [
                    {
                        "referenceName": "BlobDataset",
                        "parameters": {
                            "path": "@pipeline().parameters.inputPath"
                        },
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "BlobDataset",
                        "parameters": {
                            "path": "@pipeline().parameters.outputPath"
                        },
                        "type": "DatasetReference"
                    }
                ],
                "typeProperties": {
                    "source": {
                        "type": "BlobSource"
                    },
                    "sink": {
                        "type": "BlobSink"
                    }
                }
            }
        ],
        "parameters": {
            "inputPath": {
                "type": "String"
            },
            "outputPath": {
                "type": "String"
            }
        }
    }
}

Functions

You can call functions within expressions. The following sections provide information about the functions that can be used in an expression.

String functions

The following functions only apply to strings. You can also use a number of the collection functions on strings.

Function name	Description
concat	Combines any number of strings together. For example, if parameter1 is `foo,` the following expression would return `somevalue-foo-somevalue`: `concat('somevalue-',pipeline().parameters.parameter1,'-somevalue')` Parameter number: 1 ... n Name: String n Description: Required. The strings to combine into a single string.
substring	Returns a subset of characters from a string. For example, the following expression: `substring('somevalue-foo-somevalue',10,3)` returns: `foo` Parameter number: 1 Name: String Description: Required. The string from which the substring is taken. Parameter number: 2 Name: Start index Description: Required. The index of where the substring begins in parameter 1. Parameter number: 3 Name: Length Description: Required. The length of the substring.
replace	Replaces a string with a given string. For example, the expression: `replace('the old string', 'old', 'new')` returns: `the new string` Parameter number: 1 Name: string Description: Required. If parameter 2 is found in parameter 1, the string that is searched for parameter 2 and updated with parameter 3. Parameter number: 2 Name: Old string Description: Required. The string to replace with parameter 3 when a match is found in parameter 1 Parameter number: 3 Name: New string Description: Required. The string that is used to replace the string in parameter 2 when a match is found in parameter 1.
guid	Generates a globally unique string (aka. guid). For example, the following output could be generated `c2ecc88d-88c8-4096-912c-d6f2e2b138ce`: `guid()` Parameter number: 1 Name: Format Description: Optional. A single format specifier that indicates how to format the value of this Guid. The format parameter can be "N", "D", "B", "P", or "X". If format is not provided, "D" is used.
toLower	Converts a string to lowercase. For example, the following returns `two by two is four`: `toLower('Two by Two is Four')` Parameter number: 1 Name: String Description: Required. The string to convert to lower casing. If a character in the string does not have a lowercase equivalent, it is included unchanged in the returned string.
toUpper	Converts a string to uppercase. For example, the following expression returns `TWO BY TWO IS FOUR`: `toUpper('Two by Two is Four')` Parameter number: 1 Name: String Description: Required. The string to convert to upper casing. If a character in the string does not have an uppercase equivalent, it is included unchanged in the returned string.
indexof	Find the index of a value within a string case insensitively. For example, the following expression returns `7`: `indexof('hello, world.', 'world')` Parameter number: 1 Name: String Description: Required. The string that may contain the value. Parameter number: 2 Name: String Description: Required. The value to search the index of.
lastindexof	Find the last index of a value within a string case insensitively. For example, the following expression returns `3`: `lastindexof('foofoo', 'foo')` Parameter number: 1 Name: String Description: Required. The string that may contain the value. Parameter number: 2 Name: String Description: Required. The value to search the index of.
startswith	Checks if the string starts with a value case insensitively. For example, the following expression returns `true`: `startswith('hello, world', 'hello')` Parameter number: 1 Name: String Description: Required. The string that may contain the value. Parameter number: 2 Name: String Description: Required. The value the string may start with.
endswith	Checks if the string ends with a value case insensitively. For example, the following expression returns `true`: `endswith('hello, world', 'world')` Parameter number: 1 Name: String Description: Required. The string that may contain the value. Parameter number: 2 Name: String Description: Required. The value the string may end with.
split	Splits the string using a separator. For example, the following expression returns `["a", "b", "c"]`: `split('a;b;c',';')` Parameter number: 1 Name: String Description: Required. The string that is split. Parameter number: 2 Name: String Description: Required. The separator.

Collection functions

These functions operate over collections such as arrays, strings, and sometimes dictionaries.

Function name	Description
contains	Returns true if dictionary contains a key, list contains value, or string contains substring. For example, the following expression returns true:``contains('abacaba','aca') Parameter number: 1 Name: Within collection Description: Required. The collection to search within. Parameter number: 2 Name: Find object Description: Required. The object to find inside the Within collection.
length	Returns the number of elements in an array or string. For example, the following expression returns `3`: `length('abc')` Parameter number: 1 Name: Collection Description: Required. The collection to get the length of.
empty	Returns true if object, array, or string is empty. For example, the following expression returns `true`: `empty('')` Parameter number: 1 Name: Collection Description: Required. The collection to check if it is empty.
intersection	Returns a single array or object with the common elements between the arrays or objects passed to it. For example, this function returns `[1, 2]`: `intersection([1, 2, 3], [101, 2, 1, 10],[6, 8, 1, 2])` The parameters for the function can either be a set of objects or a set of arrays (not a mixture thereof). If there are two objects with the same name, the last object with that name appears in the final object. Parameter number: 1 ... n Name: Collection n Description: Required. The collections to evaluate. An object must be in all collections passed in to appear in the result.
union	Returns a single array or object with all of the elements that are in either array or object passed to it. For example, this function returns `[1, 2, 3, 10, 101]:` : `union([1, 2, 3], [101, 2, 1, 10])` The parameters for the function can either be a set of objects or a set of arrays (not a mixture thereof). If there are two objects with the same name in the final output, the last object with that name appears in the final object. Parameter number: 1 ... n Name: Collection n Description: Required. The collections to evaluate. An object that appears in any of the collections appears in the result.
first	Returns the first element in the array or string passed in. For example, this function returns `0`: `first([0,2,3])` Parameter number: 1 Name: Collection Description: Required. The collection to take the first object from.
last	Returns the last element in the array or string passed in. For example, this function returns `3`: `last('0123')` Parameter number: 1 Name: Collection Description: Required. The collection to take the last object from.
take	Returns the first Count elements from the array or string passed in, for example this function returns `[1, 2]`: `take([1, 2, 3, 4], 2)` Parameter number: 1 Name: Collection Description: Required. The collection to take the first Count objects from. Parameter number: 2 Name: Count Description: Required. The number of objects to take from the Collection. Must be a positive integer.
skip	Returns the elements in the array starting at index Count, for example this function returns `[3, 4]`: `skip([1, 2 ,3 ,4], 2)` Parameter number: 1 Name: Collection Description: Required. The collection to skip the first Count objects from. Parameter number: 2 Name: Count Description: Required. The number of objects to remove from the front of Collection. Must be a positive integer.

Logical functions

These functions are useful inside conditions, they can be used to evaluate any type of logic.

Function name	Description
equals	Returns true if two values are equal. For example, if parameter1 is foo, the following expression would return `true`: `equals(pipeline().parameters.parameter1), 'foo')` Parameter number: 1 Name: Object 1 Description: Required. The object to compare to Object 2. Parameter number: 2 Name: Object 2 Description: Required. The object to compare to Object 1.
less	Returns true if the first argument is less than the second. Note, values can only be of type integer, float, or string. For example, the following expression returns `true`: `less(10,100)` Parameter number: 1 Name: Object 1 Description: Required. The object to check if it is less than Object 2. Parameter number: 2 Name: Object 2 Description: Required. The object to check if it is greater than Object 1.
lessOrEquals	Returns true if the first argument is less than or equal to the second. Note, values can only be of type integer, float, or string. For example, the following expression returns `true`: `lessOrEquals(10,10)` Parameter number: 1 Name: Object 1 Description: Required. The object to check if it is less or equal to Object 2. Parameter number: 2 Name: Object 2 Description: Required. The object to check if it is greater than or equal to Object 1.
greater	Returns true if the first argument is greater than the second. Note, values can only be of type integer, float, or string. For example, the following expression returns `false`: `greater(10,10)` Parameter number: 1 Name: Object 1 Description: Required. The object to check if it is greater than Object 2. Parameter number: 2 Name: Object 2 Description: Required. The object to check if it is less than Object 1.
greaterOrEquals	Returns true if the first argument is greater than or equal to the second. Note, values can only be of type integer, float, or string. For example, the following expression returns `false`: `greaterOrEquals(10,100)` Parameter number: 1 Name: Object 1 Description: Required. The object to check if it is greater than or equal to Object 2. Parameter number: 2 Name: Object 2 Description: Required. The object to check if it is less than or equal to Object 1.
and	Returns true if both of the parameters are true. Both arguments need to be Booleans. The following returns `false`: `and(greater(1,10),equals(0,0))` Parameter number: 1 Name: Boolean 1 Description: Required. The first argument that must be `true`. Parameter number: 2 Name: Boolean 2 Description: Required. The second argument must be `true`.
or	Returns true if either of the parameters are true. Both arguments need to be Booleans. The following returns `true`: `or(greater(1,10),equals(0,0))` Parameter number: 1 Name: Boolean 1 Description: Required. The first argument that may be `true`. Parameter number: 2 Name: Boolean 2 Description: Required. The second argument may be `true`.
not	Returns true if the parameter is `false`. Both arguments need to be Booleans. The following returns `true`: `not(contains('200 Success','Fail'))` Parameter number: 1 Name: Boolean Description: Returns true if the parameter is `false`. Both arguments need to be Booleans. The following returns `true`: `not(contains('200 Success','Fail'))`
if	Returns a specified value based on if the expression provided results in `true` or `false`. For example, the following returns `"yes"`: `if(equals(1, 1), 'yes', 'no')` Parameter number: 1 Name: Expression Description: Required. A boolean value that determines which value is returned by the expression. Parameter number: 2 Name: True Description: Required. The value to return if the expression is `true`. Parameter number: 3 Name: False Description: Required. The value to return if the expression is `false`.

Conversion functions

These functions are used to convert between each of the native types in the language:

string
integer
float
boolean
arrays
dictionaries

Function name	Description
int	Convert the parameter to an integer. For example, the following expression returns 100 as a number, rather than a string: `int('100')` Parameter number: 1 Name: Value Description: Required. The value that is converted to an integer.
string	Convert the parameter to a string. For example, the following expression returns `'10'`: `string(10)` You can also convert an object to a string, for example if the foo parameter is an object with one property `bar : baz`, then the following would return `{"bar" : "baz"}` `string(pipeline().parameters.foo)` Parameter number: 1 Name: Value Description: Required. The value that is converted to a string.
json	Convert the parameter to a JSON type value. It is the opposite of string(). For example, the following expression returns `[1,2,3]` as an array, rather than a string: `json('[1,2,3]')` Likewise, you can convert a string to an object. For example, `json('{"bar" : "baz"}')` returns: `{ "bar" : "baz" }` Parameter number: 1 Name: String Description: Required. The string that is converted to a native type value. The json function supports xml input as well. For example, the parameter value of: `<?xml version="1.0"?> <root> <person id='1'> <name>Alan</name> <occupation>Engineer</occupation> </person> </root>` is converted to the following json: `{ "?xml": { "@version": "1.0" }, "root": { "person": [ { "@id": "1", "name": "Alan", "occupation": "Engineer" } ] } }`
float	Convert the parameter argument to a floating-point number. For example, the following expression returns `10.333`: `float('10.333')` Parameter number: 1 Name: Value Description: Required. The value that is converted to a floating-point number.
bool	Convert the parameter to a Boolean. For example, the following expression returns `false`: `bool(0)` Parameter number: 1 Name: Value Description: Required. The value that is converted to a boolean.
coalesce	Returns the first non-null object in the arguments passed in. Note: an empty string is not null. For example, if parameters 1 and 2 are not defined, this returns `fallback`: `coalesce(pipeline().parameters.parameter1', pipeline().parameters.parameter2 ,'fallback')` Parameter number: 1 ... n Name: Objectn Description: Required. The objects to check for `null`.
base64	Returns the base64 representation of the input string. For example, the following expression returns `c29tZSBzdHJpbmc=`: `base64('some string')` Parameter number: 1 Name: String 1 Description: Required. The string to encode into base64 representation.
base64ToBinary	Returns a binary representation of a base64 encoded string. For example, the following expression returns the binary representation of some string: `base64ToBinary('c29tZSBzdHJpbmc=')`. Parameter number: 1 Name: String Description: Required. The base64 encoded string.
base64ToString	Returns a string representation of a based64 encoded string. For example, the following expression returns some string: `base64ToString('c29tZSBzdHJpbmc=')`. Parameter number: 1 Name: String Description: Required. The base64 encoded string.
Binary	Returns a binary representation of a value. For example, the following expression returns a binary representation of some string: `binary(‘some string’).` Parameter number: 1 Name: Value Description: Required. The value that is converted to binary.
dataUriToBinary	Returns a binary representation of a data URI. For example, the following expression returns the binary representation of some string: `dataUriToBinary('data:;base64,c29tZSBzdHJpbmc=')` Parameter number: 1 Name: String Description: Required. The data URI to convert to binary representation.
dataUriToString	Returns a string representation of a data URI. For example, the following expression returns some string: `dataUriToString('data:;base64,c29tZSBzdHJpbmc=')` Parameter number: 1 Name: String Description: Required. The data URI to convert to String representation.
dataUri	Returns a data URI of a value. For example, the following expression returns data: `text/plain;charset=utf8;base64,c29tZSBzdHJpbmc=: dataUri('some string')` Parameter number: 1 Name: Value Description: Required. The value to convert to data URI.
decodeBase64	Returns a string representation of an input based64 string. For example, the following expression returns `some string`: `decodeBase64('c29tZSBzdHJpbmc=')` Parameter number: 1 Name: String Description: Returns a string representation of an input based64 string.
encodeUriComponent	URL-escapes the string that's passed in. For example, the following expression returns `You+Are%3ACool%2FAwesome`: `encodeUriComponent('You Are:Cool/Awesome')` Parameter number: 1 Name: String Description: Required. The string to escape URL-unsafe characters from.
decodeUriComponent	Un-URL-escapes the string that's passed in. For example, the following expression returns `You Are:Cool/Awesome`: `encodeUriComponent('You+Are%3ACool%2FAwesome')` Parameter number: 1 Name: String Description: Required. The string to decode the URL-unsafe characters from.
decodeDataUri	Returns a binary representation of an input data URI string. For example, the following expression returns the binary representation of `some string`: `decodeDataUri('data:;base64,c29tZSBzdHJpbmc=')` Parameter number: 1 Name: String Description: Required. The dataURI to decode into a binary representation.
uriComponent	Returns a URI encoded representation of a value. For example, the following expression returns `You+Are%3ACool%2FAwesome: uriComponent('You Are:Cool/Awesome ')` Parameter Details: Number: 1, Name: String, Description: Required. The string to be URI encoded.
uriComponentToBinary	Returns a binary representation of a URI encoded string. For example, the following expression returns a binary representation of `You Are:Cool/Awesome`: `uriComponentToBinary('You+Are%3ACool%2FAwesome')` Parameter number: 1 Name: String Description: Required. The URI encoded string.
uriComponentToString	Returns a string representation of a URI encoded string. For example, the following expression returns `You Are:Cool/Awesome`: `uriComponentToString('You+Are%3ACool%2FAwesome')` Parameter number: 1 Name: String Description: Required. The URI encoded string.
xml	Return an xml representation of the value. For example, the following expression returns an xml content represented by `'\<name>Alan\</name>'`: `xml('\<name>Alan\</name>')`. The xml function supports JSON object input as well. For example, the parameter `{ "abc": "xyz" }` is converted to an xml content `\<abc>xyz\</abc>` Parameter number: 1 Name: Value Description: Required. The value to convert to XML.
xpath	Return an array of xml nodes matching the xpath expression of a value that the xpath expression evaluates to. Example 1 Assume the value of parameter ‘p1’ is a string representation of the following XML: `<?xml version="1.0"?> <lab> <robot> <parts>5</parts> <name>R1</name> </robot> <robot> <parts>8</parts> <name>R2</name> </robot> </lab>` 1. This code: `xpath(xml(pipeline().parameters.p1), '/lab/robot/name')` would return `[ <name>R1</name>, <name>R2</name> ]` whereas 2. This code: `xpath(xml(pipeline().parameters.p1, ' sum(/lab/robot/parts)')` would return `13` Example 2 Given the following XML content: `<?xml version="1.0"?> <File xmlns="http://foo.com"> <Location>bar</Location> </File>` 1. This code: `@xpath(xml(body('Http')), '/[name()=\"File\"]/[name()=\"Location\"]')` or 2. This code: `@xpath(xml(body('Http')), '/[local-name()=\"File\" and namespace-uri()=\"http://foo.com\"]/[local-name()=\"Location\" and namespace-uri()=\"\"]')` returns `<Location xmlns="http://foo.com">bar</Location>` and 3. This code: `@xpath(xml(body('Http')), 'string(/[name()=\"File\"]/[name()=\"Location\"])')` returns `bar` Parameter number: 1 Name: Xml Description: Required. The XML on which to evaluate the XPath expression. Parameter number: 2 Name: XPath Description: Required. The XPath expression to evaluate.
array	Convert the parameter to an array. For example, the following expression returns `["abc"]`: `array('abc')` Parameter number: 1 Name: Value Description: Required. The value that is converted to an array.
createArray	Creates an array from the parameters. For example, the following expression returns `["a", "c"]`: `createArray('a', 'c')` Parameter number: 1 ... n Name: Any n Description: Required. The values to combine into an array.

Math functions

These functions can be used for either types of numbers: integers and floats.

Function name	Description
add	Returns the result of the addition of the two numbers. For example, this function returns `20.333`: `add(10,10.333)` Parameter number: 1 Name: Summand 1 Description: Required. The number to add to Summand 2. Parameter number: 2 Name: Summand 2 Description: Required. The number to add to Summand 1.
sub	Returns the result of the subtraction of the two numbers. For example, this function returns: `-0.333`: `sub(10,10.333)` Parameter number: 1 Name: Minuend Description: Required. The number that Subtrahend is removed from. Parameter number: 2 Name: Subtrahend Description: Required. The number to remove from the Minuend.
mul	Returns the result of the multiplication of the two numbers. For example, the following returns `103.33`: `mul(10,10.333)` Parameter number: 1 Name: Multiplicand 1 Description: Required. The number to multiply Multiplicand 2 with. Parameter number: 2 Name: Multiplicand 2 Description: Required. The number to multiply Multiplicand 1 with.
div	Returns the result of the division of the two numbers. For example, the following returns `1.0333`: `div(10.333,10)` Parameter number: 1 Name: Dividend Description: Required. The number to divide by the Divisor. Parameter number: 2 Name: Divisor Description: Required. The number to divide the Dividend by.
mod	Returns the result of the remainder after the division of the two numbers (modulo). For example, the following expression returns `2`: `mod(10,4)` Parameter number: 1 Name: Dividend Description: Required. The number to divide by the Divisor. Parameter number: 2 Name: Divisor Description: Required. The number to divide the Dividend by. After the division, the remainder is taken.
min	There are two different patterns for calling this function: `min([0,1,2])` Here min takes an array. This expression returns `0`. Alternatively, this function can take a comma-separated list of values: `min(0,1,2)` This function also returns 0. Note, all values must be numbers, so if the parameter is an array it has to only have numbers in it. Parameter number: 1 Name: Collection or Value Description: Required. It can either be an array of values to find the minimum value, or the first value of a set. Parameter number: 2 ... n Name: Value n Description: Optional. If the first parameter is a Value, then you can pass additional values and the minimum of all passed values are returned.
max	There are two different patterns for calling this function: `max([0,1,2])` Here max takes an array. This expression returns `2`. Alternatively, this function can take a comma-separated list of values: `max(0,1,2)` This function returns 2. Note, all values must be numbers, so if the parameter is an array it has to only have numbers in it. Parameter number: 1 Name: Collection or Value Description: Required. It can either be an array of values to find the maximum value, or the first value of a set. Parameter number: 2 ... n Name: Value n Description: Optional. If the first parameter is a Value, then you can pass additional values and the maximum of all passed values are returned.
range	Generates an array of integers starting from a certain number, and you define the length of the returned array. For example, this function returns `[3,4,5,6]`: `range(3,4)` Parameter number: 1 Name: Start index Description: Required. It is the first integer in the array. Parameter number: 2 Name: Count Description: Required. Number of integers that are in the array.
rand	Generates a random integer within the specified range (inclusive on both ends. For example, this could return `42`: `rand(-1000,1000)` Parameter number: 1 Name: Minimum Description: Required. The lowest integer that could be returned. Parameter number: 2 Name: Maximum Description: Required. The highest integer that could be returned.

Date functions

Function name	Description
utcnow	Returns the current timestamp as a string. For example `2015-03-15T13:27:36Z`: `utcnow()` Parameter number: 1 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.
addseconds	Adds an integer number of seconds to a string timestamp passed in. The number of seconds can be positive or negative. The result is a string in ISO 8601 format ("o") by default, unless a format specifier is provided. For example `2015-03-15T13:27:00Z`: `addseconds('2015-03-15T13:27:36Z', -36)` Parameter number: 1 Name: Timestamp Description: Required. A string that contains the time. Parameter number: 2 Name: Seconds Description: Required. The number of seconds to add. May be negative to subtract seconds. Parameter number: 3 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.
addminutes	Adds an integer number of minutes to a string timestamp passed in. The number of minutes can be positive or negative. The result is a string in ISO 8601 format ("o") by default, unless a format specifier is provided. For example, `2015-03-15T14:00:36Z`: `addminutes('2015-03-15T13:27:36Z', 33)` Parameter number: 1 Name: Timestamp Description: Required. A string that contains the time. Parameter number: 2 Name: Minutes Description: Required. The number of minutes to add. May be negative to subtract minutes. Parameter number: 3 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.
addhours	Adds an integer number of hours to a string timestamp passed in. The number of hours can be positive or negative. The result is a string in ISO 8601 format ("o") by default, unless a format specifier is provided. For example `2015-03-16T01:27:36Z`: `addhours('2015-03-15T13:27:36Z', 12)` Parameter number: 1 Name: Timestamp Description: Required. A string that contains the time. Parameter number: 2 Name: Hours Description: Required. The number of hours to add. May be negative to subtract hours. Parameter number: 3 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.
adddays	Adds an integer number of days to a string timestamp passed in. The number of days can be positive or negative. The result is a string in ISO 8601 format ("o") by default, unless a format specifier is provided. For example `2015-02-23T13:27:36Z`: `adddays('2015-03-15T13:27:36Z', -20)` Parameter number: 1 Name: Timestamp Description: Required. A string that contains the time. Parameter number: 2 Name: Days Description: Required. The number of days to add. May be negative to subtract days. Parameter number: 3 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.
formatDateTime	Returns a string in date format. The result is a string in ISO 8601 format ("o") by default, unless a format specifier is provided. For example `2015-02-23T13:27:36Z`: `formatDateTime('2015-03-15T13:27:36Z', 'o')` Parameter number: 1 Name: Date Description: Required. A string that contains the date. Parameter number: 2 Name: Format Description: Optional. Either a single format specifier character or a custom format pattern that indicates how to format the value of this timestamp. If format is not provided, the ISO 8601 format ("o") is used.

Next steps

For a list of system variables you can use in expressions, see System variables.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

control-flow-expression-language-functions.md

control-flow-expression-language-functions.md

Expressions and functions in Azure Data Factory

Introduction

Expressions

Examples

A dataset with a parameter

A pipeline with a parameter

Functions

String functions

Collection functions

Logical functions

Conversion functions

Math functions

Date functions

Next steps

Files

control-flow-expression-language-functions.md

Latest commit

History

control-flow-expression-language-functions.md

File metadata and controls

Expressions and functions in Azure Data Factory

Introduction

Expressions

Examples

A dataset with a parameter

A pipeline with a parameter

Functions

String functions

Collection functions

Logical functions

Conversion functions

Math functions

Date functions

Next steps