CDatebeforereadingbasicsyntaxcrystalsyntax

Returns the date value of the argument.

Usage:

CDate( x )
CDate( YYYY, MM, DD )

Parameters:

x	either a string or a datetime or a number to be converted to a date value. If a string, it must be one which is able to be interpreted as a date, such as "September 23, 2004". If a number, then measured in days since December 30,1899 (note this number can be fractional, it will then be truncated)

Here are the current formats supported by i-net Clear Reports:

M/d/yy h:mm a
M/d/yy h:mma
d. MMMM yyyy HH:mm:ss z
dd.MM.yyyy HH:mm:ss
dd.MM.yyyy HH:mm
dd.MM.yyyy
MMM dd, yy h:mm a
MMM dd, yy h:mma
MMM dd, yy HH:mm
MMM dd, yy
MMM dd yyyy
MMM. dd, yy h:mm a
MMM. dd, yy h:mma
MMM. dd, yy HH:mm
MMM. dd, yy
MMMM dd, yy
dd-MMM-yyyy hh:mm:ss a
dd-MMM-yyyy hh:mm:ssa
dd-MMM-yyyy HH:mm:ss
dd MMM yyyy h:mm a
dd MMM yyyy h:mma
dd MMM yyyy HH:mm
dd-MMM-yyyy h:mm a
dd-MMM-yyyy h:mma
dd-MMM-yyyy HH:mm
dd-MM-yyyy hh:mm:ss a
dd-MM-yyyy hh:mm:ssa
dd-MM-yyyy HH:mm:ss
dd-MM-yyyy h:mm a
dd-MM-yyyy h:mma
dd-MM-yyyy HH:mm
dd-MM-yyyy
dd-MMM-yyyy
yyyy-MM-dd hh:mm:ss a
yyyy-MM-dd hh:mm:ssa
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd
MM/dd/yy h:mm:ss a
MM/dd/yy h:mm:ssa
MM/dd/yy H:mm:ss
yyyy/M/dd h:mm:ss a
yyyy/M/dd h:mm:ssa
yyyy/M/dd HH:mm:ss
MM/dd/yy h:mm a
MM/dd/yy h:mma
MM/dd/yy H:mm
MM/dd/yy
MM-yy
dd/MMM/yyyy:HH:mm:ss z
h:mm:ss a
h:mm:ssa
HH:mm:ss
h:mm a
h:mma
HH:mm
E,MMM dd, yyyy
yyyy.MM.dd
dd MMM yy"

Legend:

d - Day as number
dd - Day as two-digit number
M - month as number
MM - month as two-digit number
MMM - month as three-letter abbreviation
MMMM - full month name
yy - year as two-digit number
yyyy - full year
h - Hour of day
hh - Two-digit hour of day
mm - Two-digit minute of hour
ss - two-digit second of minute
a - AM/PM
z - Time zone ("Pacific Standard Time"; "PST"; "GMT-08:00"; "+0100"...)

Note: These patterns will be matched in descending order. This first pattern of this list, which matches the input parameter will be used to interprete the date/time value. If you encounter an unexpected result, please check the pattern list.

YYYY, MM, DD	Three numbers specifying the year, month and day of month of the date.

Localization

The output format depends on the locale set in the report. If no locale is specified for the report, the server locale will be used instead.

Important: The client locale has no influence on the result.

Examples:

CDate(623456)      // Returns 12/17/06
CDate(1981,04,15)  // Returns 04/15/81