+ Add

Number

Number

Numerical addition.

1.2 + 3 = 4.2

Date

Integer number

Adds days to the date.

31/01/2021 + 7 = 07/02/2021

- Subtract

Number

Number

Numerical subtraction.

1.2 - 3 = -1.8

Date

Integer number

Subtracts days from the date.

31/01/2021 - 7 = 24/01/2021

Date

Date

Days the date in Value 1 is after the date in Value 2 (negative if before).

31/01/2021 - 24/01/2021 = 7

24/01/2021 - 31/01/2021 = -7

* Multiply

Number

Number

Numerical multiplication.

1.2 * 3 = 3.6

/ Divide

Number

Number

Numerical division.

1.2 / 3 = 0.4

1 / 0 = Error

^ Power

Number

Number

Column 1 to the power Column 2 (col1col2).

1.2 ^ 3 = 1.728

2 ^ -3 = 0.125

% Modulus

Integer number

Integer number

Remainder after Value 1 is divided by Value 2.

7 % 2 = 1

7 % 0 = Error

Abs

Number

N/A

The absolute value.

Abs( 1.2 ) = 1.2

Abs( -1.2 ) = 1.2

And

Boolean

Boolean

Logical AND.

And( true, false ) = false 

And( 1, 1 ) = true 

And( 0, FALSE ) = false

Ceiling

Number

N/A

The smallest integer that is not less than the value.

Ceiling( 1 ) = 1

Ceiling( 1.2 ) = 2

Ceiling( -1.2 ) = -1

DayOfWeek

Date

N/A

Day of the week, from 1 = Monday to 7 = Sunday.

DayOfWeek( 31/01/2021 ) = 7

DayOfWeek( 01/02/2021 ) = 1

DayOfMonth

Date

N/A

Day of the month, from 1 to 31.

DayOfMonth( 31/01/2021 ) = 31

DayOfMonth( 01/02/2021 ) = 1

DayOfYear

Date

N/A

Day of the year, from 1 to 366.

DayOfYear( 01/02/2021 ) = 32

DayOfYear( 31/12/2021 ) = 365

Decrement

Number

N/A

Subtract 1.

Decrement( 1 ) = 0

Decrement( -1 ) = -2

Decrement( 1.2 ) = 0.2 

Date

N/A

Subtract 1 day.

Decrement( 31/01/2021 ) = 30/01/2021

Floor

Number

N/A

The largest integer that is not greater than the value.

Floor( 1 ) = 1

Floor( 1.2 ) = 1

Floor( -1.2 ) = -2

Increment

Number

N/A

Add 1.

Increment( 1 ) = 2 

Increment( -1 ) = 0 

Increment( 1.2 ) = 2.2 

Date

N/A

Add 1 day.

Increment( 31/01/2021 ) = 01/02/2021

JulianDay

Date

N/A

Days since the beginning of the Julian period.

JulianDay( 31/01/2021 ) = 2459246

JulianDay( 01/02/2021 ) = 2459247

Length

Any

N/A

Then number of characters in the value (include any whitespace).

Length( 1.2 ) = 3

Length( 31/01/2021 ) = 10

Length( abcd ) = 4

LevDistance

Any

Any

Calculates the Levenshtein distance between 2 text values. Case sensitive.

LevDistance( Easy Data, easydata ) = 3

Ln

Number

N/A

The natural (base e) logarithm of the value.

Ln ( 10 ) = 2.302

Ln ( 0 ) = Error

Maximum

Number

Number

Returns the larger number.

Maximum( 10, 11 ) = 11

Maximum( 10, -11 ) = 10

Date

Date

Returns the later date.

Maximum( 31/01/2021, 01/01/2022 ) = 01/01/2022

Minimum

Number

Number

Returns the smaller number.

Minimum( 10, 11 ) = 10

Minimum( 10, -11 ) = -11

Date

Date

Returns the earlier date.

Minimum( 31/01/2021, 01/01/2021 ) = 31/01/2021

Log10

Number

N/A

The common (base 10) logarithm of the value.

Log10( 10 ) = 1

Log10( 0 ) = Error

Month

Date

N/A

1 = January.

Month( 31/12/2021 ) = 12

Or

Boolean

Boolean

Logical OR.

Or( true, false ) = true 

Or( 1, 1 ) = true 

Or( 0, FALSE ) = false

Round

Number

N/A

Round to the nearest integer.

Round( 1 ) = 1

Round( -1.2 ) = -1

Round( 1.5 ) = 2

Sign

Number

N/A

1 if value > 0, 0 if value = 0, -1 of value < 0.

Sign( 1.2 ) = 1

Sign( 0 ) = 0

Sign( -1.2 ) = -1

WeekOfYear

Date

N/A

The year and the week of the year, from 01 to 53, separated with a comma. In accordance with ISO 8601, each week falls in the year to which most of its days belong, in the Gregorian calendar. As ISO 8601's week starts on Monday, this is the year in which the week's Thursday falls.

WeekOfYear( 31/12/2020 ) = 2020,53

WeekOfYear( 06/01/2021 ) = 2021,01

WeekOfYear( 31/12/2021 ) = 2021,52

Xor

Boolean

Boolean

Logical XOR (exclusive OR).

Xor( true, false ) = true 

Xor( 1, 1 ) = false 

Xor( 0, FALSE ) = false

Year

Date

N/A

The 4 digit year.

Year( 31/01/2021 ) = 2021