FunctionOperatorTypeEx Enum

Contains date-time functions used in Pivot Grid controls.

Namespace: DevExpress.PivotGrid.Criteria

Assembly: DevExpress.PivotGrid.v25.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

public enum FunctionOperatorTypeEx

VB.NET

Public Enum FunctionOperatorTypeEx

Members

Name	Description
GetDateQuarterYear	Returns the date of the first day of the quarter for the specified DateTime.
GetDateMonthYear	Returns the date of the first day of the month for the specified DateTime.
GetDateWeekYear	Returns the date of the first day of the week for the specified DateTime (uses culture settings).
GetDateHour	Extracts the date part with the hour value from the defined DateTime.
GetDateHourMinute	Extracts the date part with the hour and minute values from the defined DateTime.
GetDateHourMinuteSecond	Extracts the date part with hour, minute, and second values from the defined DateTime.
GetQuarter	Extracts the quarter from the defined DateTime.
GetWeekOfMonth	Extracts the week of the month from the defined DateTime.
GetWeekOfYear	Extracts the week of the year from the defined DateTime.
ToDateTime	Converts the value to a DateTime value.
ToDate	Converts the value to a DateOnly value.
ToTime	Converts the value to a TimeOnly value.
ToBoolean	Converts the value to an equivalent Boolean value.
ToByteArray	Converts the value to a byte array value.
ToDayOfWeek	Converts the value to a DayOfWeek value.
GetYearAge	Returns age in years. Age is determined by number of elapsed full years between the specified date and the current date.
GetMonthAge	Returns the age in months. Age is determined by number of elapsed full months between the specified date and the current date.
GetWeekAge	Returns age in weeks. Age is determined by number of elapsed full weeks between the specified date and the current date.
GetDayAge	Returns age in days. Age is determined by number of elapsed full days between the specified date and the current date.