Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.

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