AnsweredAssumed Answered

Find interval between dates action - decimals?

Question asked by glenda on Mar 2, 2015
Latest reply on Mar 5, 2015 by andrewg@intellinet.com


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

Outcomes