Date Arithmetic Expressions

DayDifference

Description:

The DayDifference operation creates a Result by determing the number of days that seperate Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

DayDifference

WeekDifference

Description:

The WeekDifference operation creates a Result by determing the number of weeks that seperate Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

WeekDifference

MonthDifference

Description:

The MonthDifference operation creates a Result by determing the number of months that seperate Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

MonthDifference

YearDifference

Description:

The YearDifference operation creates a Result by determing the number of years that seperate Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal