Skip to main content
Row

PivotGroupingValue.FromDateTime(DateTime, Boolean) Method

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

public static PivotGroupingValue FromDateTime(
    DateTime value,
    bool use1904DateSystem
)

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.

See Also