Manuals/calci/DATE
Jump to navigation
Jump to search
DATE (Year,Month,Date,IsLocalTime)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Year} represents the year.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Month} is the month of the year.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Date} is the date.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IsLocalTime}
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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle year} 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.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle month} 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.
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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DATE(Year,Month,Date,IsLocalTime)} .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle year} represents the year.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle month} is the month of the year.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle date} 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