Manuals/calci/DATEVALUE

DATEVALUE(String)

• $String$ represents a date in CALCI format

Description

• This function gives the serial number of the given $String$.
• This is used to convert a date in the form of text to a specified serial number.
• By default , the serial number starts from 1/1/1900.
• i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918.
• This function will give the result as Error, when the $String$ is below 1/1/1900.
• If the year value is not entered in the $String$, this function will consider the current year.
• Time information in $String$ is ignored.

ZOS Section

• The syntax for the function DATEVALUE in ZOS is $DATEVALUE(String)$.
• $String$ is representing the date in the required format.
• For e.g.,DATEVALUE(#1998/01/01..1998/1/15)

DATEVALUE

Examples

• =DATEVALUE("3/20/2005")=38431
• =DATEVALUE("6/7/1960")=58599
• =DATEVALUE("1-APR-1976")=27851
• =DATEVALUE("12/12")=37237 for the current year 2013.

Related Videos

DATE VALUE

See Also

• DATE
• DAY

References

Complex Numbers