Set Date from Date using Number

Set Date from Date using Number

Action

... set date to number days after date keeping time
Info
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
Info
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.
Notes
monday.com provides the ability to push a date by a number of seconds. While monday.com 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 ...

    • 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 ...

    • Clear a Mirror Column

      Clears the columns mirrored by a mirror column across all items. monday.com has a limit on the number of items that can be changed per minute by an app. Beware that if you have many connected items, it will fail to clear all items - and negatively ...

    • Copy Columns

      Copy Columns is a Column Magic feature that can copy the value of one column to another, including mirror columns that mirror a single item. Multiple trigger types are provided for copying mirrors, special columns, or local columns - or the value of ...

    • Evaluate Expression to Column

      Evaluate Expression is not a spreadsheet formula function, and does not use the syntax of monday.com formulas. It is meant for mathematical expressions. Evaluates a MathJS expression and stores the result in the selected column. Use actions in the ...