Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtract Number Value from Date

Hello!   I am working in the query editor and looking to have a custom column as specified below ...   Date # Days (Whole number data type) NEW CUSTOM COLUMN 1/10/2020 1 1/9/2020 1/1...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this:

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

     

djmini's avatar
djmini
Frequent Visitor
5 years ago

As an alternative to the above, setting the 'data type' of the column holding the number of days to 'Duration' allows it to be used in a Custom Column, with a simple Date column + or - Duration Column formula.

  • mwhoskisson's avatar
    mwhoskisson
    New Member
    3 years ago

    This worked for me and is very simple. Thanks!