Skip to main content
Nintex Community Menu Bar

Calculating Date Difference

  • March 26, 2020
  • 3 replies
  • 61 views

TX0708
Forum|alt.badge.img+1

I am calculating the number of days between the current date and another anchor date and when the number equals a certain amount, the workflow will send notification as a reminder that tasks need to be completed. I have the correct function of fn-DateDiffDays(current date, anchor date on nintex form)

I also have a workflow variable to convert this and put into "DateDifference". I also have a column on my list titled DateDifferenceStatus. How do I make the number of days appear on my list under that DateDifferenceStatus column I made?

3 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • March 26, 2020
Hi,

Use an update item action to update the DateDifferenceStatus column with the variable.

TX0708
Forum|alt.badge.img+1
  • Author
  • March 26, 2020
Hi! Yes I do have an update item action. And the function is working because I do see the correct number of days when I click "view statistics" on that workflow. Under List settings for that column, I have it as single line of text with the default to read 365 (since the max is one year, I just added that part).

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • March 26, 2020
So what is the issue?