Manuals/calci/AGINGINDAYS - Revision history

Swapna: /* Description */

2019-02-15T11:38:15Z

Description

Devika: /* Examples */

2019-02-07T20:32:59Z

Examples

Devika at 19:12, 22 May 2018

2018-05-22T19:12:24Z

Devika: /* Description */

2018-05-15T18:55:42Z

Description

Devika: Created page with "
'''AGINGINDAYS (Day,From)'''

* $Day$ is any date. * $From$ is also any date value. ==Description== *This function s..."

2017-08-09T22:36:32Z

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..."

New page

<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 ]]

@@ Line 4: / Line 4: @@
 ==Description==
-*This function shows the value of  Aging in days.
+*This function displays 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.
+*In <math>AGINGINDAYS(Day,From)</math> ,<math>Day</math>  is any date value.From value is also any date value which is to subtracted from the given date.
-*So this  formula subtracts the first date value from the original second  date.
+*This  formula subtracts the first date value from the original second date.
-*This calculates number of days in between  those given dates.
+*This calculates number of days in between the given dates.
-*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
+*DD/MM/YYYY format can also be used. For Example:"14/5/2005[DD/MM/YYYY]".
-*We can use Range values also. For Example: AGINGINDAYS("12/10/2030",#6/12/2017-8/13/2017)
+*Range values also can be used. For Example: AGINGINDAYS("12/10/2030",#6/12/2017-8/13/2017)
-* #date notation needs  mm/dd/yy format .
+* #date notation needs  mm/dd/yy format.
 ==Examples==

@@ Line 8: / Line 8: @@
 *So this  formula subtracts the first date value from the original second  date.
 *This calculates number of days in between  those given dates.
 *We can use Range values also. For Example: AGINGINDAYS("12/10/2030",#6/12/2017-8/13/2017)
 * #date notation needs  mm/dd/yy format .