Set Date from Date using Number

Set Date from Date using Number


... set date to number days after date keeping time
Use this action in the custom automation builder to create recipes. There are no pre-built automation templates for this action.

Function Details

  1. Sets a date column in relation to another date column, based on a number in a numbers column.
  2. Can be configured to set the date before or after the source date.
  3. Can be configured to ignore the time in the source column.
  4. Supports the following time periods to add/subtract from the source date:
    1. days
    2. weeks
    3. months
    4. business days
    5. hours
    6. minutes
    7. seconds
Ignoring the time while setting the date x hours/minutes/seconds will remove the time from the final result after calculation. This means if 4 hours is added to 5:00 PM - the result is 9:00 PM and the resulting date will be the same without the time. If 10 hours is added to 5:00 PM, the result will be the next day without a time. provides the ability to push a date by a number of seconds. While only stores and displays the minutes of a time, you can still add/subtract a number of seconds. This option exists for consistency. We'd love to hear your use case for using seconds.

    • Related Articles

    • Push Date Keeping Time

      Action ... push date by some days keeping the time Template Triggers When status changes to something... When date arrives push... Use actions in the custom automation builder to support additional triggers, and trigger conditions! Function Details ...
    • Write Text Pattern With Date Format

      Date Format templates and actions extend the standard "...write text pattern to column" and "...write text pattern to item name" by allowing you to specify a custom format for all dates. Action ...write text pattern to column with date format ...
    • Set Status on Upload/Delete of File

      Sets a status column value according to the last activity in a file column Function Details Sets a status based on last activity (add or delete) in a file column Due to limitations, app actions that set statuses cannot be used in custom ...
    • Column Magic Automations

      Column Magic is a feature of automations that provides the individual automations in the app that are not part of a suite of templates. Automations Evaluate Expression to Column Push Date Keeping Time Set Date from Date using Number Expand Team to ...
    • List of all available date formats

      Format Output Description YY 23 Two-Digit Year YYYY 2023 Four-Digit Year M 1-12 The month, beginning at 1 MM 01-12 The month, 2-digit MMM Jan-Dec The abbreviated month name MMMM January-December The full month name D 1-31 The day of the month DD ...