next up previous contents index
Next: DAY Up: A. Function Reference Previous: DATE   Contents   Index


DATEVALUE

Syntax: DATEVALUE(S)

S = string value of a date

DATEVALUE returns the corresponding date value for a given string S.

It interprets the data in the following formats:

MM/DD/YY  
DD-MMM-YY  
MMM-YY (assumes the first of the month)
DD.MM.YY  

In all formats, the year may be omitted, in which case it defaults to the current year.

The year may be given as 2 or 4 digits. A two year digit assumes the 20th century.

In the above formats, the month (MMM) is case insensitive and may be either the standard 3 letter abbreviation or the full name of the month.

Examples:

DATEVALUE(``3/24/1954'') = 19807

DATEVALUE(``3/24/54'') = 19807

DATEVALUE(``4-July-1994'') = 34519

DATEVALUE(``4-July'') = 34519, where the year is omitted, and assuming the year is 1994.

DATEVALUE(``September-94'') = 34578

DATEVALUE(``Sep-1994'') = 34578

DATEVALUE(``SEP'') = 34578, where the year is omitted, and assuming the year is 1994.

DATEVALUE(``06.04.66'') = 24203

DATEVALUE(``06.04.1966'') = 24203

CAUTION: When the year is defaulted, the value returned by DATEVALUE will vary depending on the year. For example, if you are using SpreadScript late on New Year's Eve 1991, the function DATEVALUE(``1-Jan'') will return 33239 before midnight and 33604 after midnight.

Excel function: DATEVALUE


next up previous contents index
Next: DAY Up: A. Function Reference Previous: DATE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003