Difference between revisions of "Manuals/calci/DAYSINYEARTILLDATE"
Jump to navigation
Jump to search
(→ZOS) |
|||
Line 17: | Line 17: | ||
*DAYSINYEARTILLDATE("1-7-2017") = 7day (Output inZOS, Z3) | *DAYSINYEARTILLDATE("1-7-2017") = 7day (Output inZOS, Z3) | ||
*DAYSINYEARTILLDATE("4-FEB-2014") = 35day (Output inZOS, Z3) | *DAYSINYEARTILLDATE("4-FEB-2014") = 35day (Output inZOS, Z3) | ||
− | *DAYSINYEARTILLDATE(Date(2017,1,7)) = | + | *DAYSINYEARTILLDATE(Date(2017,1,7)) = 79day (Output in ZCALCI) |
− | |||
==Related Videos== | ==Related Videos== |
Revision as of 12:37, 19 March 2018
DAYSINYEARTILLDATE(Date)
- where is the date till which number of days are to be found.
Description
- This function calculates the number of days from the first day of the year to the specified date of the same year.
- The output is the integer value.
- Date should be entered in the DATE function format. i.e DATE(2014,1,7) for 7th day of January, 2014.
- For e.g:DAYSINYEARTILLDATE(Date(2017,1,7))
ZOS
- The syntax is to calculate DAYSINYEARTILLDATE in ZOS, Z3 and ZCALCI is .
- is the date for which number of days are to be found.
Examples
- DAYSINYEARTILLDATE("2017,1,7")= 7day (Output inZOS, Z3)
- DAYSINYEARTILLDATE("1-7-2017") = 7day (Output inZOS, Z3)
- DAYSINYEARTILLDATE("4-FEB-2014") = 35day (Output inZOS, Z3)
- DAYSINYEARTILLDATE(Date(2017,1,7)) = 79day (Output in ZCALCI)
Related Videos
See Also
References