Date calculation in Nintex

  • 25 July 2017
  • 2 replies
  • 10 views

Badge +8

Hi,

Here is my scenaio:

I am querying list and collecting "Date initiated" column values into a collection variable. I now would like to iterate through each date initiated value and calculate "Number of days in Approval" which is a difference between (current date and Date initiated). I then update the number of days in approval field in the list item.

Sounds simple but with dates involved in the collection, I am not able to achieve this.

  • I iterate through Date initiated collection and store each date in "var_datestring" String variable. 
  • I then use convert value to use "datediffdays" function to calculate the difference between var_datestring and current date.

I schedule this workflow once a day and the workflow ends with the error below

205906_pastedImage_1.png

Collection Operation Configuration:

205919_pastedImage_2.png

Convert value action configuration.

205920_pastedImage_3.png

Error received:

205921_pastedImage_1.png


2 replies

Userlevel 5
Badge +14

Hi, cvuppala‌, what's the reason for reposting your question once again while you are headed to the solution here ?

Badge +6

Hi cvuppala ,

 Please check this ,

https://community.nintex.com/thread/16781-calculate-date-based-on-another-date 

Thanks

Bashya Rajan A

Reply