Skip to main content
Nintex Community Menu Bar

Day Difference expression incorrect

  • February 2, 2017
  • 0 replies
  • 8 views

Forum|alt.badge.img+15


 

Symptoms


Format M/d/yyyy
1. 12/30/2014 - 1/2/2015 Result = 3
2. 12/30/2015 - 1/2/2016 Result = 2
3. 12/30/2016 - 1/2/2017 Result = 4
4. 12/30/2017 - 1/2/2018 Result = 3
Why?

 

Diagnoses



 

Resolution

As a workaround, please try the following expression:
(DateTo - DateFrom) / 86400000