Solved

Find interval between dates action - decimals?

  • 2 March 2015
  • 1 reply
  • 5 views

Badge +8


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 Date End Date Amount of days calculated
03/03/2015 09/03/2015 5.96
16/03/2015 23/03/2015 7
21/03/2015 28/03/2015 7
18/12/2015 31/12/2015 13
03/03/2015 10/03/2015 6.96

 

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

 

Thanks a lot,

 

Glenda

icon

Best answer by andrewg 6 March 2015, 04:07

View original

1 reply

Userlevel 7
Badge +17

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.

Reply