PivotGroupingValue.FromDateTime(DateTime, Boolean) Method

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

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

public static PivotGroupingValue FromDateTime(
    DateTime value,
    bool use1904DateSystem
)

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.