No ratings

Day Difference expression incorrect




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





Version history
Last update:
‎02-01-2017 05:53 PM
Updated by:
Contributors