cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
glenda
Nintex Newbie

Find interval between dates action - decimals?

Jump to solution


Guys,

I am trying to calculate the amount of days between two dates but sometimes my result ends up decimal.

My variable "Aantal verlofdagen/amount of leave days" is of type Number as the find interval between dates action only allows this data type.

Configuration of action:

1.PNG

I was writing my result down to my history list to check the output of the variable. This is were I noticed the strange behaviour. A few examples:

23/03/2015

Start DateEnd DateAmount of days calculated
03/03/201509/03/20155.96
16/03/201523/03/20157
21/03/201528/03/20157
18/12/201531/12/201513
03/03/201510/03/20156.96

I don't get what it does... someone maybe an idea?

Thanks a lot,

Glenda

Labels: (1)
0 Kudos
Reply
1 Reply
Automation Master
Automation Master

Re: Find interval between dates action - decimals?

Jump to solution

Is it possible that Start Date or End Date is a Date & Time field?

It looks like it read one of the dates as an Hour off.

0 Kudos
Reply