Xojo Documentation Xojo Documentation

Property (As DateTime )

aDatabaseColumn.DateTimeValue = newDateTimeValue
or
DateTimeValue = aDatabaseColumn.DateTimeValue

New in 2019r2

Supported for all project types and targets.

Used to get and set the values of DateTime field types.

Notes

For situations where you need to set a database column to NULL, you should use the Value property like this:

rs.EditRow
rs.DateTimeColumn("MyDateColumn").Value = Nil // sets to NULL in the database
rs.SaveRow

Sample Code

Get the date value of a column in a RowSet:

// rs is a RowSet with a date column called "InvoiceDate"
Var invoiceDate As DateTime
invoiceDate = rs.Column("InvoiceDate").DateTimeValue

Set the date value of a column in a RowSet:

// rs is a RowSet with a date column called "InvoiceDate":
rs.EditRow
Var d As New DateTime
rs.DateTimeColumn("InvoiceDate").DateTime = d
rs.SaveRow