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

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 NExS late on New Year's Eve 1991, the function @DATEVALUE(``1-Jan'') will return 33239 before midnight and 33604 after midnight.


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999