Difference between revisions of "Manuals/calci/DATE"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (13 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''DATE (Year,Month,Date,IsLocalTime)'''</div><br/> |
| − | + | *<math>Year</math> represents the year. | |
| + | *<math>Month</math> is the month of the year. | ||
| + | *<math>Date</math> is the date. | ||
| + | *<math>IsLocalTime</math> is the logical value. | ||
| + | **DATE(),returns the serial number of a particular date. | ||
| − | </ | + | ==Description== |
| − | - | + | *This function gives the sequential serial number for the given date. |
| − | < | + | *Here <math>year</math> represents the year and the argument is of one to four digits. |
| + | *i.e.,The year is starting from 1 and there is no restriction for the argument. | ||
| + | *<math>month</math> is the month of the year and it is from 1 to 12(January to December). | ||
| + | *It may be positive or negative. when we are geving with the positive value more than 12, it will get adding that number of months to the first month in the year specified. For e.g.DATE(2017,15,30) = 3/30/2018. | ||
| + | *Suppose the argument is negative, it will get subtracted that number of months plus 1 from the first month in the year specified.For e.g.,DATE(2020,-5,13) = 7/13/2019. | ||
| + | *<math>date</math> is the date of the month of the year and it is from 1 to 31. | ||
| + | *The date argument also with the value of positive or negative.If the date is more than the number of days in the month then the day adds that number of days to the first day in the month.For e.g DATE(2012,9,40) = 10/10/2012. | ||
| + | *Suppose the argument is negative,day subtracts that number of days plus 1 from the first day in the month specified.For e.g.,DATE(2013,7,-12) = 6/18/2013. | ||
| − | + | ==ZOS== | |
| + | *The syntax is to calculate DATE in ZOS is <math>DATE(Year,Month,Date,IsLocalTime)</math>. | ||
| + | *<math>year</math> represents the year. | ||
| + | *<math>month</math> is the month of the year. | ||
| + | *<math>date</math> is the date. | ||
| + | *For e.g.,DATE(#2013/2/14..2013/3/1) | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *DATE(99,2,1)=2/1/99 | |
| + | *DATE(1600,12,31)=12/31/1600 | ||
| − | + | ==Related Videos== | |
| − | |||
| − | |||
| − | + | {{#ev:youtube|BGFRdiRjBkc|280|center|DATE}} | |
| − | + | ==See Also== | |
| − | |||
| − | |||
| − | + | *[[Manuals/calci/DATEVALUE | DATEVALUE ]] | |
| + | *[[Manuals/calci/DAYS360 | DAYS360 ]] | ||
| − | + | ==References== | |
| + | [http://en.wikipedia.org/wiki/Calendar_date DATE] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 13:44, 22 August 2018
DATE (Year,Month,Date,IsLocalTime)
- represents the year.
- is the month of the year.
- is the date.
- is the logical value.
- DATE(),returns the serial number of a particular date.
represents the year.
is the month of the year.
is the date.
is the logical value.
Description
- This function gives the sequential serial number for the given date.
- Here represents the year and the argument is of one to four digits.
- i.e.,The year is starting from 1 and there is no restriction for the argument.
- is the month of the year and it is from 1 to 12(January to December).
- It may be positive or negative. when we are geving with the positive value more than 12, it will get adding that number of months to the first month in the year specified. For e.g.DATE(2017,15,30) = 3/30/2018.
- Suppose the argument is negative, it will get subtracted that number of months plus 1 from the first month in the year specified.For e.g.,DATE(2020,-5,13) = 7/13/2019.
- is the date of the month of the year and it is from 1 to 31.
- The date argument also with the value of positive or negative.If the date is more than the number of days in the month then the day adds that number of days to the first day in the month.For e.g DATE(2012,9,40) = 10/10/2012.
- Suppose the argument is negative,day subtracts that number of days plus 1 from the first day in the month specified.For e.g.,DATE(2013,7,-12) = 6/18/2013.
represents the year and the argument is of one to four digits.
is the month of the year and it is from 1 to 12(January to December).
is the date of the month of the year and it is from 1 to 31.ZOS
- The syntax is to calculate DATE in ZOS is .
- represents the year.
- is the month of the year.
- is the date.
- For e.g.,DATE(#2013/2/14..2013/3/1)
.Examples
- DATE(99,2,1)=2/1/99
- DATE(1600,12,31)=12/31/1600
Related Videos
See Also
References