Back to: Index of transforms
Transforms in this section operate on a time data type. Learn more about how to search for and add a transformation.
Shift a date by a duration. Returns a new time column at a specified number of weeks, days, hours, minutes, seconds, or milliseconds before or after your input date/time column.
Shift an input timestamp.
Use a static time as a column.
Create a range starting from 00:00 on the input date to the input date.
Creates date range starting from 00:00 of the first day (either Monday or Sunday, as defined by user's locale) of input date's week to the input date.
Create a range starting from 00:00 on the first day of the input date's month to the input date.
Create a range starting from 00:00 on January 1st of the input date's year to the input date.
Gets the day of week from a date as a number.
Gets the day of month from a date as a number.
Gets the day of year from a date as a number.
Gets the hour of day from a date as a number.
Gets the month from a date as a number.
Gets the year from a date as a number.
Convert a string representation of a date, for example 18/07/2023 or July 18, 2023 into a date type. Set the timezone to be used to a specific timezone, Local or UTC. Optionally, also provide the date format for parsing in dayjs format ↗.
Convert a numeric representation of a date (either Unix seconds or milliseconds, representing a timestamp in UTC) to a date type. This transform is useful, for example, to convert the returned value (number data type) of a numeric aggregation on an object set Date property back to a Date type, to be used as input for other transforms or cards.