DATEVALUE Function


Function Type

Predefined function

Syntax

DATEVALUE( <dateString> )

Description

Converts a character string representation of a date into a date value.

<dateString> - Formatted date string to be converted into a real date value.

The DATEVALUE function understands dates in the following formats. The results are calculated assuming the current year is 1994.

Format

Example

Result (yyyymmdd)

mm-dd-yyyy

07-12-1994

19940712

mm-dd-yy

12-03-94

19941203

mm-dd

11-25

19941125

mm/dd/yyyy

01/01/1955

19550101

mm/dd/yy

09/23/47

19470923

mm/dd

08/03

19940803

dd-mon-yyyy

12-Jun-1983

19830612

dd-mon-yy

15-Mar-01

19940315

dd-mon

30-Sep

19940930

dd-month-yyyy

31-October-2315

23151031

dd-month-yy

10-August-58

19580810

dd-month

01-April

19940401

Returns

Date

Example

This example converts a formatted date in a literal string to a date value.

DATEVALUE("01/01/1955")


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*