Difference between revisions of "Manuals/calci/DATESERIAL"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DATESERIAL (DateValue)'''</div><br/> *<math>DateValue</math> is any date value. ==Description== *This function shows the date serial value for ...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 8: | Line 8: | ||
*We can specify relative dates for each argument using any numeric expression that represents some number of days, months, or years before or after a certain date. | *We can specify relative dates for each argument using any numeric expression that represents some number of days, months, or years before or after a certain date. | ||
*When any argument exceeds the accepted range for that argument, it increments to the next larger unit as appropriate. | *When any argument exceeds the accepted range for that argument, it increments to the next larger unit as appropriate. | ||
| − | *For example, if you specify 35 days, it is evaluated as one month and some number of days, depending on where in the year it is applied. *If the date specified by the three arguments falls outside the acceptable range of dates, an error occurs. | + | *For example, if you specify 35 days, it is evaluated as one month and some number of days, depending on where in the year it is applied. |
| + | *If the date specified by the three arguments falls outside the acceptable range of dates, an error occurs. | ||
==Examples== | ==Examples== | ||
| Line 14: | Line 15: | ||
# DATESERIAL("152") = "0151-12-31T18:30:00.000Z" | # DATESERIAL("152") = "0151-12-31T18:30:00.000Z" | ||
# DATESERIAL("98") = "1997-12-31T18:30:00.000Z" | # DATESERIAL("98") = "1997-12-31T18:30:00.000Z" | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=zMSHlE3Y9Po|280|center|Date Serial}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:35, 7 February 2019
DATESERIAL (DateValue)
- is any date value.
is any date value.Description
- This function shows the date serial value for the given date.
- In , is any date value.
- Here date value should be from 1 to 31 and 1 to 12 for months.
- We can specify relative dates for each argument using any numeric expression that represents some number of days, months, or years before or after a certain date.
- When any argument exceeds the accepted range for that argument, it increments to the next larger unit as appropriate.
- For example, if you specify 35 days, it is evaluated as one month and some number of days, depending on where in the year it is applied.
- If the date specified by the three arguments falls outside the acceptable range of dates, an error occurs.
,Examples
- DATESERIAL("45") = "2044-12-31T18:30:00.000Z"
- DATESERIAL("152") = "0151-12-31T18:30:00.000Z"
- DATESERIAL("98") = "1997-12-31T18:30:00.000Z"
Related Videos
See Also
References