FilterValue.FromDateTime(DateTime, Boolean) Method

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

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

public static FilterValue FromDateTime(
    DateTime value,
    bool use1904DateSystem
)

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

Parameters

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

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.

See Also

FilterValue Class

FilterValue Members

DevExpress.Spreadsheet Namespace