How can I calculate the exact age between two dates?
for example: birth date 04/05/1972
                        hiring date 02/03/2010
  the exact age should be 37 and not 38.


Hi gmontano


The Time Difference Node outputs you the difference between two dates. Increase the number of diggits (to which the difference get rounded to something big like 20) and set the granularity to Year

Finally you can round the difference down to the next smaller whole number using the Double to Int Node with the option floor.


Best, Iris

Hi Iris,


If I have a date of birth as a timestamp. eg. 02.Nov. 1965 how can I derive the exaxt age?

which node I need to use?

With the time difference node and the option use Execution time.

Cheers, Iris