0

I initially tried to create this as a Calculated Column. But, of course, they don't like [Today] as a variable. I'm trying to populate a column with a number that is a calculation based upon a date someone enters into another column. So the calculation would be: 

[Today] - [PastDate]

With the impossibility of creating this in a Calc Column, I'm now looking at a workflow for this (using Nintex, of course). How would I go about doing this calculation in a workflow (since that seems to be my only option) ?

Improve this question

2 Answers 2

Reset to default
1

Based on many references on this in Stack Exchange, you can use Today() instead of [Today] like:

=TODAY()-DateOne
Improve this answer
1
  • Thank you, Matiur .
    – DanJ
    Commented Jan 29, 2020 at 16:28
1

In addition to Martiur's response, to calculate the number of days you can use the DateDif function:

=DATEDIF(Start_date,End_date,"D") -> "D" for number of days.

E.g.:

  1. Create a calculated column of type number
  2. Formula

=DATEDIF(Today(),[PastDate],"D")

Microsoft Article

Improve this answer
1
  • That's good to know. Thank you.
    – DanJ
    Commented Jan 29, 2020 at 16:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.