Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 9: | Line 9: | ||
*Also <math>firstdate</math> and <math>seconddate</math> we have to give in [[Manuals/calci/DATE | DATE]] function format. | *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>. | *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== | ==ZOS== | ||
| Line 18: | Line 20: | ||
==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 |
==Related Videos== | ==Related Videos== | ||
| Line 32: | Line 34: | ||
==References== | ==References== | ||
*[http://en.wikipedia.org/wiki/360-day_calendar| 360DAYS] | *[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