CDATE

Returns an expression that has been converted to a variant of subtype Date.

The format of the date returned by the function depends on the system locale.

Syntax

CDATE(date)

CDATE recognizes date literals and time literals and some numbers that fall within the range of acceptable dates. When converting a number to a date, the whole number portion is converted to a date. Any fractional part of the number is converted to a time of day, starting at midnight.

CDATE recognizes date formats according to the locale setting of the computer. The correct order of day, month, and year might not be determined if it is provided in a format other than one of the recognized date settings. Additionally, a long date format is not recognized if it also contains the day-of-the-week string.

You can use this syntax to reference a date field from a product table:

CDATE({<table>\<fieldname>})

Examples

This example compares a due date and a specific date:

If CDATE({LA\Due Date}) < CDATE("2002/02/02") Then
Result = 0
ElseResult = 1
End If

This example returns "01/01/2016":

CDATE("1 January 2016")

This example returns "02/02/2002":

CDATE("2002-02-02")

This example returns "03/02/2002":

CDATE({LA\Due Date})