DateInputFormat Property

The DateInputFormat property sets or returns the order of year, month, and day components of input date values.

Syntax

Column .DateInputFormat

Applies To

Column Object

Discussion

This property uses the values of xtrDateFormat. Use the trPredefined constant when the format is defined in your data source, such as in a spreadsheet that has date-formatted cells.

Type

Constant - xtrDateFormat

Access

Read/Write

Examples

objDataSource 
= objModel.DataSources.Add(xtrObjectType.trFlatFileDataSource)objDataSource
	.Columns("EuroDate").DateInputFormat
= xtrDateFormat.trMDY