Date and Time Expressions

Year

Description:

The Year operation creates a Result by parsing the Year from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Year

Quarter

Description:

The Quarter operation creates a Result by parsing the Quarter from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Quarter

Month

Description:

The Month operation creates a Result by parsing the Month from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Month

DayOfYear

Description:

The DayOfYear operation creates a Result by parsing the Day Of Year from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

DayOfYear

Day

Description:

The Day operation creates a Result by parsing the Day from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Day

Week

Description:

The Week operation creates a Result by parsing the Week from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Week

Weekday

Description:

The Weekday operation creates a Result by parsing the Weekday from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Weekday

Hour

Description:

The Hour operation creates a Result by parsing the Hour from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Hour

Minute

Description:

The Minute operation creates a Result by parsing the Minute from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Minute

Second

Description:

The Second operation creates a Result by parsing the Second from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Second

YearQuarter

Description:

The YearQuarter operation creates a Result by parsing the YearQuarter from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

YearQuarter

YearMonth

Description:

The YearMonth operation creates a Result by parsing the YearMonth from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

YearMonth

FromUnixTimeStamp

Description:

The FromUnixTimeStamp operation creates a Result by converting Input 1 from a Unix Time Stamp.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

FromUnixTimeStamp

ToUnixTimeStamp

Description:

The ToUnixTimeStamp operation creates a Result by converting Input 1 into a Unix Time Stamp.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

ToUnixTimeStamp

MinutesFromNow

Description:

The MinutesFromNow operation creates a Result by calculating how many Minutes there are from now until Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

MinutesFromNow

HoursFromNow

Description:

The HoursFromNow operation creates a Result by calculating how many Hours there are from now until Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

HoursFromNow

DaysFromNow

Description:

The DaysFromNow operation creates a Result by calculating how many Days there are from now until Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

DaysFromNow

CombineDateAndTime

Description:

The CombineDateAndTime operation creates a Result by combining the Date in Input 1 with the Time in Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time
  • String
  • TimeSpan

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time
  • String
  • TimeSpan

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

CombineDateAndTime

AddMinutes

Description:

The AddMinutes operation creates a Result by adding the specified number of Minutes in Input 2 to a Date in Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

CombineDateAndTime

AddHours

Description:

The AddHours operation creates a Result by adding the specified number of Hours in Input 2 to a Date in Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

AddHours

AddDays

Description:

The AddDays operation creates a Result by adding the specified number of Days in Input 2 to a Date in Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

AddDays

ToUniversalTime

Description:

The ToUniversalTime operation creates a Result by converting Input 1 to Universal Time.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time (Utc)

ToUniversalTime

ToLocalTime

Description:

The ToLocalTime operation creates a Result by converting Input 1 to Local Time.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time (Local)

ToLocalTime

ChangeKindToUTC

Description:

The ChangeKindToUTC operation creates a Result by changing the type of Date/Time in Input 1 to UTC.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time (Utc)

ChangeKindToUTC

ChangeKindToLocal

Description:

The ChangeKindToLocal operation creates a Result by changing the type of Date/Time in Input 1 to Local.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time (Local)

ChangeKindToLocal

QuarterString

Description:

The QuarterString operation creates a Result by parsing the QuarterString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

QuarterString

QuarterYearString

Description:

The QuarterYearString operation creates a Result by parsing the QuarterYearString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

QuarterYearString

MonthString

Description:

The MonthString operation creates a Result by parsing the MonthString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

MonthString

MonthYearString

Description:

The MonthYearString operation creates a Result by parsing the MonthYearString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

MonthYearString

DayOfWeekString

Description:

The DayOfWeekString operation creates a Result by parsing the DayOfWeekString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

DayOfWeekString

QuarterMonthString

Description:

The QuarterMonthString operation creates a Result by parsing the QuarterMonthString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

QuarterMonthString

DayOfMonthTwoDigit

Description:

The DayOfMonthTwoDigit operation creates a Result by parsing the DayOfMonthTwoDigit from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

DayOfMonthTwoDigit

AbbreviatedDayOfWeek

Description:

The AbbreviatedDayOfWeek operation creates a Result by parsing the AbbreviatedDayOfWeek from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

AbbreviatedDayOfWeek

FullDayOfWeek

Description:

The FullDayOfWeek operation creates a Result by parsing the FullDayOfWeek from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FullDayOfWeek

FullDateTimeLong

Description:

The FullDateTimeLong operation creates a Result by parsing the FullDateTimeLong from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FullDateTimeLong

FullDateTimeShort

Description:

The FullDateTimeShort operation creates a Result by parsing the FullDateTimeShort from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FullDateTimeShort

HourTwoDigitMilitary

Description:

The HourTwoDigitMilitary operation creates a Result by parsing the HourTwoDigitMilitary from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HourTwoDigitMilitary

HourSingleDigitMilitary

Description:

The HourSingleDigitMilitary operation creates a Result by parsing the HourSingleDigitMilitary from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HourSingleDigitMilitary

HourTwoDigitRegular

Description:

The HourTwoDigitRegular operation creates a Result by parsing the HourTwoDigitRegular from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HourTwoDigitRegular

HourSingleDigitRegular

Description:

The HourSingleDigitRegular operation creates a Result by parsing the HourSingleDigitRegular from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HourSingleDigitRegular

HundredthsOfSecond

Description:

The HundredthsOfSecond operation creates a Result by parsing the HundredthsOfSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HundredthsOfSecond

LongDate

Description:

The LongDate operation creates a Result by parsing the LongDate from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

LongDate

LongTime

Description:

The LongTime operation creates a Result by parsing the LongTime from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

LongTime

Milliseconds

Description:

The Milliseconds operation creates a Result by parsing the Milliseconds from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

Milliseconds

FullMonth

Description:

The FullMonth operation creates a Result by parsing the FullMonth from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FullMonth

AbbreviatedMonth

Description:

The AbbreviatedMonth operation creates a Result by parsing the AbbreviatedMonth from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

AbbreviatedMonth

MonthDay

Description:

The MonthDay operation creates a Result by parsing the MonthDay from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

MonthDay

RFC1123

Description:

The RFC1123 operation creates a Result by parsing the RFC1123 from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RFC1123

RoundTrip

Description:

The RoundTrip operation creates a Result by parsing the RoundTrip from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

RoundTrip

SingleDigitSecond

Description:

The SingleDigitSecond operation creates a Result by parsing the SingleDigitSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SingleDigitSecond

TwoDigitSecond

Description:

The TwoDigitSecond operation creates a Result by parsing the TwoDigitSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TwoDigitSecond

ShortTime

Description:

The ShortTime operation creates a Result by parsing the ShortTime from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

ShortTime

SortableDateTime

Description:

The SortableDateTime operation creates a Result by parsing the SortableDateTime from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SortableDateTime

TenThousandthsOfSecond

Description:

The TenThousandthsOfSecond operation creates a Result by parsing the TenThousandthsOfSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TenThousandthsOfSecond

HundredThousandthsOfSecond

Description:

The HundredThousandthsOfSecond operation creates a Result by parsing the HundredThousandthsOfSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

HundredThousandthsOfSecond

UniversalFullDateTime

Description:

The UniversalFullDateTime operation creates a Result by parsing the UniversalFullDateTime from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

UniversalFullDateTime

UniversalSortable

Description:

The UniversalSortable operation creates a Result by parsing the UniversalSortable from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

UniversalSortable

TwoDigitYear

Description:

The TwoDigitYear operation creates a Result by parsing the TwoDigitYear from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TwoDigitYear

TenthsOfSecond

Description:

The TenthsOfSecond operation creates a Result by parsing the TenthsOfSecond from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

TenthsOfSecond

MonthDayNumeric

Description:

The MonthDayNumeric operation creates a Result by parsing the MonthDayNumeric from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

MonthDayNumeric

YearMonthDayNumeric

Description:

The YearMonthDayNumeric operation creates a Result by parsing the YearMonthDayNumeric from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

YearMonthDayNumeric

NextWeekDay

Description:

The NextWeekDay operation creates a Result by parsing the NextWeekDay from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double
  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double
  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

CombineDateAndTime

CurrentDate

Description:

The CurrentDate operation creates a Result by taking a Time as Input 1 and appending it to the Current Date.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

CurrentDate

AddBusinessDays

Description:

The AddBusinessDays operation creates a Result by adding the specified number of Business Days in Input 2 to the Date/Time in Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Int32
  • Int64
  • Int16
  • Double

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Date/Time

AddBusinessDays

SkipHoliday

Description:

The SkipHoliday operation creates a Result by parsing the SkipHoliday from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Date/Time

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

SkipHoliday

FormatString

Description:

The FormatString operation creates a Result by parsing the FormatString from Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • String
  • Date/Time
  • TimeSpan

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • String

FormatString