FilterValue.FromDateTime(DateTime, Boolean) Method

Converts the DateTime object to a filter value using the specified date system.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

public static FilterValue FromDateTime(
    DateTime value,
    bool use1904DateSystem
)

VB.NET

Public Shared Function FromDateTime(
    value As Date,
    use1904DateSystem As Boolean
) As FilterValue

Parameters

Name	Type	Description
value	DateTime	A DateTime object that specifies a date and time value to be converted to a filter value.
use1904DateSystem	Boolean	true, to use the 1904 date system; otherwise, false.

Returns

Type	Description
FilterValue	A FilterValue object that specifies a value for the filter criteria.

Remarks

If you use the 1904 date system, the date is represented as a serial number of elapsed days since January 1, 1904. False value indicates that the 1900 date system is used, where January 1, 1900 is the first day in the system. By default, the workbook uses the 1900 date system.