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.
