DateValue - SQL Function

DateValue(DateParameter: String/Date/Time/DateTime [,String: String]): Date

DateValue returns a date value for DateParameter, optionally using the String parameter to specify the format of DateParameter (either Day Month Year or Month Day Year). If String is omitted, assumes the format of DateParameter matches the default date / time format.

DateValue function syntax has these named arguments:

Parameter	Description
DateParameter	Required. Parameter to be formatted as a date. This can be a String, Date, Time or DateTime value, including ISO 8601 Date Time strings.
String	Optional. Date format for the DateParameter. If not entered, uses the default date / time format. Select from: Day Month Year Month Day Year

Parameter

Description

DateParameter

Required. Parameter to be formatted as a date. This can be a String, Date, Time or DateTime value, including ISO 8601 Date Time strings.

String

Optional. Date format for the DateParameter. If not entered, uses the default date / time format. Select from:

Day Month Year
Month Day Year