Date and Time Utilities

Overview

This plug-in aims to eliminate the need for custom date and time calculation rules. It contains many functions for common date and time manipulation, with an emphasis on the Appian Date and Time data type. It uses Java's native Date and Calendar classes so it is fast and of minimal size.  The functions are listed below and also covered in greater detail in the document included in the file download.

  • Adding Units of Time
    • addYears
    • addMonths
    • addDays
    • addHours
    • addMinutes
    • addSeconds
  • Subtracting Units of Time
    • subtractYears
    • subtractMonths
    • subtractDays
    • subtractHours
    • subtractMinutes
    • subtractSeconds
  • Comparisons
    • sameYear
    • sameMonth
    • sameDay
    • sameHour
    • sameMinute
    • sameSecond
  • Elapsed Time
    • elapsedTime
    • elapsedYears
    • elapsedMonths
    • elapsedDays
    • elapsedHours
    • elapsedMinutes
    • elapsedSeconds
    • elapsedMillis
  • Text Parsing
    • isValidDate
    • parseDate
  • ISO 8601 Conversion
    • toIsoDateString
    • fromIsoDateString
  • Retrieval
    • nowWithParameter
Anonymous
Parents
  • v1.3.0 Release Notes
    • Added two functions:
    • These functions convert an Appian Datetime value to and from the standard Unix Timestamp integer representation. It is the number of seconds that have elapsed since the Unix epoch, excluding leap seconds. The Unix epoch is 00:00:00 UTC on 1 January 1970.
    • toUnixTimestamp - Returns the Unix timestamp from datetime
    • fromUnixTimestamp - Returns a Date and Time value by converting a Unix timestamp.
Comment
  • v1.3.0 Release Notes
    • Added two functions:
    • These functions convert an Appian Datetime value to and from the standard Unix Timestamp integer representation. It is the number of seconds that have elapsed since the Unix epoch, excluding leap seconds. The Unix epoch is 00:00:00 UTC on 1 January 1970.
    • toUnixTimestamp - Returns the Unix timestamp from datetime
    • fromUnixTimestamp - Returns a Date and Time value by converting a Unix timestamp.
Children