You can use the Date Math tool to extract parts of date columns - such as a weekday or year. It is particularly helpful in combinations with others tools.

The columns you use in the Date Math tool must be formatted as a date/datetime. Use the Change Columns tool to change column formats.

​
Configuration

The Date Math tool consists of two required input.

1

Input Column Name

The Date Math tool will create a new column. Use this input to name it.

2

Select Date Column

Select the column that you want to add/subtract a duration to/from

3

Select Unit

Select the unit you want to add/subtract to/from your date column. You can select one of the following:

  • Seconds
  • Minutes
  • Hours
  • Days
  • Weekdays
  • Months
  • Years
4

Input Number of Units

Input the number of units that you want to add/subtract from your date column. Simply put a - (minus) in front of the number of units to subtract instead of add.

You can reference column values in this input. Check out the examples below. However, you cannot reference columns when adding or subtracting months or years.

​
When To Use

The Date Math is helpful whenever you need to create a reference date:

  • For instance by adding a the payment term to an invoice date to get the due date
  • Add a dynamic number of days to a previous contact with a client to create a reminder to check-in
  • Calculate renewal dates for a subscription license

​
Examples

You can use the Date Math tool to extract parts of date columns - such as a weekday or year. It is particularly helpful in combinations with others tools.

The columns you use in the Date Math tool must be formatted as a date/datetime. Use the Change Columns tool to change column formats.

​
Configuration

The Date Math tool consists of two required input.

1

Input Column Name

The Date Math tool will create a new column. Use this input to name it.

2

Select Date Column

Select the column that you want to add/subtract a duration to/from

3

Select Unit

Select the unit you want to add/subtract to/from your date column. You can select one of the following:

  • Seconds
  • Minutes
  • Hours
  • Days
  • Weekdays
  • Months
  • Years
4

Input Number of Units

Input the number of units that you want to add/subtract from your date column. Simply put a - (minus) in front of the number of units to subtract instead of add.

You can reference column values in this input. Check out the examples below. However, you cannot reference columns when adding or subtracting months or years.

​
When To Use

The Date Math is helpful whenever you need to create a reference date:

  • For instance by adding a the payment term to an invoice date to get the due date
  • Add a dynamic number of days to a previous contact with a client to create a reminder to check-in
  • Calculate renewal dates for a subscription license

​
Examples