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.


  • 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 get the current time using the Current Date/Time Module, pass the output to the Round Date/Time Module to set the date to the start of the quarter, and then 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.

Was this article helpful?