Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| 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 <math> | + | *Here <math>firstdate</math> and <math>seconddate</math> are two dates to find the number of in between days. |
| − | *Also <math> | + | *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>. | ||
| + | |||
| + | ==ZOS Section== | ||
| + | *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. | ||
==Examples== | ==Examples== | ||
| − | |||
*DAYSBETWEEN("2/28/2008","3/13/2008")=15 | *DAYSBETWEEN("2/28/2008","3/13/2008")=15 | ||
*DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366 | *DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366 | ||
==See Also== | ==See Also== | ||
| − | |||
*[[Manuals/calci/DAYS360 | DAYS360]] | *[[Manuals/calci/DAYS360 | DAYS360]] | ||
*[[Manuals/calci/DATE | DATE]] | *[[Manuals/calci/DATE | DATE]] | ||
| Line 20: | Line 26: | ||
==References== | ==References== | ||
| + | *[[http://en.wikipedia.org/wiki/360-day_calendar | 360 DAYS]] | ||
Revision as of 03:26, 18 April 2014
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 .
ZOS Section
- 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