DateTimeFormat Property (DateTimeCellType)

Gets or sets a DateTimeFormatInfo that defines the format for displaying dates and times.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Property DateTimeFormat As DateTimeFormatInfo

'Usage
 
Dim instance As DateTimeCellType
Dim value As DateTimeFormatInfo
 
instance.DateTimeFormat = value
 
value = instance.DateTimeFormat

public override DateTimeFormatInfo DateTimeFormat {get; set;}

Property Value

DateTimeFormatInfo object containing the format for date-time values

Example

FarPoint.Web.Spread.DateTimeCellType dt = new FarPoint.Web.Spread.DateTimeCellType();
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.LongDatePattern = "D";
dtf.ShortDatePattern = "M/d/yyyy";
dt.DateTimeFormat = dtf;
dt.MaximumValue = new Date(2020, 12, 31);
dt.MinimumValue = new Date(1950, 1, 1);
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = dt;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;

Visual Basic

Dim dt As New FarPoint.Web.Spread.DateTimeCellType
Dim dtf As New System.Globalization.DateTimeFormatInfo
dtf.LongDatePattern = "D"
dtf.ShortDatePattern = "M/d/yyyy"
dt.DateTimeFormat = dtf
dt.MaximumValue = New Date(2020, 12, 31)
dt.MinimumValue = New Date(1950, 1, 1)
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = dt
FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now

Reference

DateTimeCellType Class
DateTimeCellType Members