<<

Contents

Search

>>

 

NUMDATE

 

 

Function

 

 

Syntax:

NUMDATE(<Date>)

 

<Date> = <STRING-EXPRESSION>

 

Meaning:

Returns the numeric value of an alphanumeric date.

 

NUMDATE converts a date string into a number.

 

The date must have the valid date form of the respective country (e.g. MM/DD/YYYY or MM/DD/YY). The result is thus returned as numeric value in the form YYYYMMDD or YYMMDD.  

 

If  <Date> is invalid, –1 is returned.

 

Parameter:

Date

Alphanumeric date

 

Sample:

DATUM% = NUMDATE(DATEG8$)

 

See also:

STRDATE$

DATEADD

DATEDIFF

DAYOFWEEK

WEEKOFYEAR

DATE$

DATEG$

DATEG8$