writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''AGINGINDAYS (Day,From)'''</div><br/> *<math>Day</math> is any date. *<math>From</math> is also any date value. ==Description== *This function s..."
<div style="font-size:30px">'''AGINGINDAYS (Day,From)'''</div><br/>
*<math>Day</math> is any date.
*<math>From</math> is also any date value.
==Description==
*This function shows the value of Aging in days.
*In <math>AGINGINDAYS(Day,From)</math> ,<math>Day</math> is any date value.From value is also any date value which is to be get subtracted from the given date.
*So this formula subtracts the first date value from the original second date.
*This calculates number of days in between those given dates.
==Examples==
# AGINGINDAYS("12/10/2030","6/12/2017") = 4929
# AGINGINDAYS("6/19/2003","1/7/2009") = -2029
# AGINGINDAYS("2/29/2020","3/1/2020") = -1
==See Also==
*[[Manuals/calci/DATEVALUE | DATEVALUE ]]
*[[Manuals/calci/DAYS360 | DAYS360 ]]
==References==
[http://en.wikipedia.org/wiki/Calendar_date DATE]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>Day</math> is any date.
*<math>From</math> is also any date value.
==Description==
*This function shows the value of Aging in days.
*In <math>AGINGINDAYS(Day,From)</math> ,<math>Day</math> is any date value.From value is also any date value which is to be get subtracted from the given date.
*So this formula subtracts the first date value from the original second date.
*This calculates number of days in between those given dates.
==Examples==
# AGINGINDAYS("12/10/2030","6/12/2017") = 4929
# AGINGINDAYS("6/19/2003","1/7/2009") = -2029
# AGINGINDAYS("2/29/2020","3/1/2020") = -1
==See Also==
*[[Manuals/calci/DATEVALUE | DATEVALUE ]]
*[[Manuals/calci/DAYS360 | DAYS360 ]]
==References==
[http://en.wikipedia.org/wiki/Calendar_date DATE]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]