PivotGroupingValue.FromDateTime(DateTime, Boolean) Method

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public static PivotGroupingValue FromDateTime(
    DateTime value,
    bool use1904DateSystem
)

VB.NET

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

Parameters

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

Returns

Type	Description
PivotGroupingValue	A PivotGroupingValue object that specifies a starting or ending value for grouping.

Remarks

If you use the 1904 date system, the date is represented as the 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.