Difference between revisions of "Manuals/calci/DAYSBETWEEN"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''DAYSBETWEEN( First date, Second date)'''</font></font> <br /> ...") |
|||
| (16 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''DAYSBETWEEN(firstdate,seconddate)'''</div><br/> |
| − | < | + | *<math>firstdate</math> is the starting date. |
| + | *<math>seconddate</math> is the end date. | ||
| − | < | + | ==Description== |
| + | *This function gives the number of days between the first date and the second date(30 days in 12 months). | ||
| + | *Here <math>firstdate</math> and <math>seconddate</math> are two dates to find the number of in between days. | ||
| + | *Also <math>firstdate</math> and <math>seconddate</math> we have to give in [[Manuals/calci/DATE | DATE]] function format. | ||
| + | *This function will give the result as error when the <math>seconddate</math> is before the <math>firstdate</math>. | ||
| + | **We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]". | ||
| − | |||
| − | |||
| − | |||
| − | < | + | ==ZOS== |
| + | *The syntax is to calculate DAYSBETWEEN in ZOS is <math>DAYSBETWEEN(firstdate,seconddate)</math>. | ||
| + | *<math>firstdate</math> is the starting date. | ||
| + | *<math>seconddate</math> is the end date. | ||
| + | *For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222. | ||
| + | {{#ev:youtube|uzjJ_2v2MVw|280|center|Days between}} | ||
| − | + | ==Examples== | |
| − | + | *=DAYSBETWEEN("2/28/2008","3/13/2008")=15 | |
| − | + | *=DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366 | |
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|4CfTkI37jaM|280|center|DAYS360}} | |
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/DAYS360 | DAYS360]] | ||
| + | *[[Manuals/calci/DATE | DATE]] | ||
| + | *[[Manuals/calci/DAY | DAY]] | ||
| − | + | ==References== | |
| + | *[http://en.wikipedia.org/wiki/360-day_calendar| 360DAYS] | ||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 13:34, 22 May 2018
DAYSBETWEEN(firstdate,seconddate)
- is the starting date.
- is the end date.
is the starting date.
is the end date.Description
- This function gives the number of days between the first date and the second date(30 days in 12 months).
- Here and are two dates to find the number of in between days.
- Also and we have to give in DATE function format.
- This function will give the result as error when the is before the .
- We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
ZOS
- The syntax is to calculate DAYSBETWEEN in ZOS is .
- is the starting date.
- is the end date.
- For e.g.,DAYSBETWEEN("2/1/1999","3/2/2005") = 2222.
Examples
- =DAYSBETWEEN("2/28/2008","3/13/2008")=15
- =DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366
Related Videos
See Also
References