Documentation

Date/Time cards

Cards in this section return and display date/time values.

Object property
Shift date/time
Transform table column values
Date/time parameter
Time range parameter
Coalesce
Time series start date
Time series end date
Day to date
Week to date
Month to date
Year to date
String to date

Object property

Takes as input an object and displays a property on a card. Supported property types are Numeric, Time, and String.

Shift date/time

Takes as input a date/time value and returns a date/time shifted by a number of weeks/days/hours/minutes/seconds or milliseconds from the input date.

Transform table column values

Takes a date/time column from a transform table as input, and returns an array of the date/time values.

Date/time parameter

Create a date/time input field which can be used as a parameter in other cards (for example, filters or formulas).

Time range parameter

Create a time range input field which can be used as a parameter in other cards (for example, filters or formulas). Use the Select separate start and end date parameter setting in the editor to set the start and end date/times to be defined by distinct date/time parameters.

For example, if you would like a filter to be based on the start and end time of an event object, you can define separate date/time parameters for each start and end date/times of the event object, then use these date/time parameters to define a time range parameter.

Learn more about time ranges.

Coalesce

Returns the first value that is not null, or null if all inputs are null.

Time series start date

Returns the date of the first point in a time series.

Time series end date

Returns the date of the last point in a time series.

Day to date

Create a range starting from 00:00 on the input date to the input date.

Week to date

Create a range starting from 00:00 on the Monday of the input date's week to the input date.

Month to date

Create a range starting from 00:00 on the first day of the input date's month to the input date.

Year to date

Create a range starting from 00:00 on January 1st of the input date's year to the input date.

String to date

Convert a string into a date. American date format is used by default (mm/dd/yyyy). Other date formats are parsable by providing a date format. Will return Invalid timezone or date for invalid values.