SqlMethods.DateDiffMonth Method (Nullable<DateTime>, Nullable<DateTime>)
[ This article is for Windows Phone 8 developers. If you’re developing for Windows 10, see the latest documentation. ]
Counts the number of month boundaries between two nullable dates.
Assembly: System.Data.Linq (in System.Data.Linq.dll)
public static Nullable<int> DateDiffMonth( Nullable<DateTime> startDate, Nullable<DateTime> endDate )
Parameters
- startDate
- Type: System.Nullable<DateTime>
The start date for the time period.
- endDate
- Type: System.Nullable<DateTime>
The end date for the time period.
Return Value
Type: System.Nullable<Int32>When both parameters are not null, returns the number of month boundaries between the two specified dates. When one or both parameters are null, returns a null value.
Corresponds to the SQL Server DATEDIFF function; using month to specify the type of time boundary crossed. For more about this SQL Server function, see DATEDIFF in the Microsoft SQL Server Books Online.
Show: