writer
6,694
edits
Changes
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 ..."
<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 the given date.
*In <math>DATESERIAL (DateValue)</math>,<math>DateValue</math> 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"
==See Also==
*[[Manuals/calci/DATE | DATE]]
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
*[[Manuals/calci/DAY | DAY]]
==References==
*[http://en.wikipedia.org/wiki/Calendar_date Day]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>DateValue</math> is any date value.
==Description==
*This function shows the date serial value for the given date.
*In <math>DATESERIAL (DateValue)</math>,<math>DateValue</math> 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"
==See Also==
*[[Manuals/calci/DATE | DATE]]
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
*[[Manuals/calci/DAY | DAY]]
==References==
*[http://en.wikipedia.org/wiki/Calendar_date Day]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]