Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| (15 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''DAYSBETWEEN( | + | <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== | ==Description== | ||
*This function gives the number of days between the first date and the second date(30 days in 12 months). | *This function gives the number of days between the first date and the second date(30 days in 12 months). | ||
| − | *Here | + | *Here <math>firstdate</math> and <math>seconddate</math> are two dates to find the number of in between days. |
| − | *Also | + | *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== | ==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== | ==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 14: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