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
ValeIT
Offline
Last seen: 5 years 1 month ago
Joined: 05/17/2018 - 04:08
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
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
Hi ValeIT,
That is great. Glad you were able to adapt something to your needs.
Brian