DateValue

Syntax

SQL.DateValue(DateTime[, DenyTimePart][, UseMinTimeValue][, useMaxTimeValue])

Description

Formats a date in SQL text, including parameterizable time values.

Parameter	Description
DateTime	A valid date value.
DenyTimePart	Optional. If TRUE, only a date is created.
useMinTimeValue	Optional. If TRUE, a time value of 00:00:00,000 is added to the date.
useMaxTimeValue	Optional. If TRUE, a time value of 23:59:59,999 is added to the date.

See Also

NumberValue, TextValue

Example

Sub Main()
 
    MsgBox SQL.DateValue(Now(), , , True) ' 2011-09-09 23:59:59.999
 
End Sub