Calculate the difference of days between 2 dates?

ValeIT

Forums

Hello
Is it possible to make a script that calculates the difference of days between 2 dates and add this difference in a new field ?
Example:
Sales              Payment      DATEDIF
05/05/2018 07/05/2018    2 
I know that on Excel the function is datedif (french translate function).
However, I do not find an equivalent function on IDEA 10.Thank you
 
 

Brian Element Wed, 06/20/2018 - 12:20

HI ValeIT,

Is this for the equation editor?  If that is the case you can use the @Age(Date1, Date2) function the returns the number of days between the two dates.  Date1 is usually the later date.

Let me know if this is what you are looking for.

Brian

ValeIT Fri, 06/22/2018 - 08:14

Hello Bryan,
I find the Payment Date vs Due Date script, I change some stuff with the @age function and it's works :)
Thank you

Brian Element Fri, 06/22/2018 - 08:51

Hi ValeIT,

That is great.  Glad you were able to adapt something to your needs.

Brian