Applies to

Bridge by Smartsheet

Bridge utilities: Date/Time

Parse, validate, manipulate, and format human readable or machine readable dates and/or times in Bridge.

Who can use this?

Plans:

  • Bridge by Smartsheet

There are five high-level operations you can achieve using this extension: Getting, Setting, Checking, Comparing, and Formatting dates and/or times. Dates and times are represented by a structured date/time object; while durations (differences between two dates) are represented using duration-object. Both can be passed from one module to another.

For example, if you want to get the start of the current business quarter in the standard ISO-8601 format, you can:

  1. First, get the current time using the Current Date/Time Module.
  2. Next, pass the output to the Round Date/Time Module to set the date to the start of the quarter.
  3. Finally, use the Format Date/Time Module to output the Date/Time object into a formatted string – in this case ISO-8601.

The Date/Time utility contains the following modules:

  • Check Date/Time

    Check an input date against specified conditions and route your template accordingly. 

  • Compare Date/Time

    Compare two parsed date objects resulting in the absolute difference between them.

  • Current Date/Time

    Returns the current date/time into a structured Date object that you can manipulate or format.

  • Format Date/Time

    Formats the output of another module to give a human readable form.

  • Manipulate Date/Time

    Add or subtract a unit of time from a parsed date object.

  • Parse Date/Time

    Parses an input into a structured Date/Time that you can manipulate for format. This module can parse human readable dates, ISO-8601, RFC 2822, Unix timestamps and more formats.

  • Round Date/Time

    Returns the start or end of a Date/Time object of unit in time.