Difference between revisions of "Manuals/calci/DAYSINYEARTILLDATE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''DAYSINYEARTILLDATE(Date)'''</div><br/> *where <math>Date</math> is the date till which number of days are to be found. ==Description== *This fu...")
 
Line 9: Line 9:
  
 
==ZOS==
 
==ZOS==
*The syntax is to calculate DAYSINYEARTILLDATE in ZOS, Z3 and ZCALCI is <math>DAYSINYEARTILLDATE(Year)</math>.
+
*The syntax is to calculate DAYSINYEARTILLDATE in ZOS, Z3 and ZCALCI is <math>DAYSINYEARTILLDATE(Date)</math>.
 
*<math>Date</math> is the date for which number of days are to be found.
 
*<math>Date</math> is the date for which number of days are to be found.
 
  
 
==Examples==
 
==Examples==

Revision as of 05:46, 18 March 2017

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)) = 7day (Output in ZCALCI)


Related Videos

DAY

See Also

References