EntityFunctions.DiffYears Method (Nullable<DateTime>, Nullable<DateTime>)

.NET Framework (current version)

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions.

Namespace:   System.Data.Objects
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

[EdmFunctionAttribute("Edm", "DiffYears")]
public static Nullable<int> DiffYears(
	Nullable<DateTime> dateValue1,
	Nullable<DateTime> dateValue2


Type: System.Nullable<DateTime>

A valid date.

Type: System.Nullable<DateTime>

A valid date.

Return Value

Type: System.Nullable<Int32>

The number of years between dateValue1 and dateValue2.

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database.

.NET Framework
Available since 4.0
Return to top