Syntax
public static int DaysBetweenDates( this int fromDate, int toDate )
public static int DaysBetweenDates( this string fromDate, string toDate )
public int DaysBetweenDates( int fromDate, int toDate )
public int DaysBetweenDates( string fromDate, string toDate )
Parameter Description
| fromDate | Starting date |
| toDate | Ending date |
Description
Determines the number of calendar days including weekends between the two specified dates, Date1 and Date2, in yyyyMMdd format (which you can easily reconfigure by following the standard
Date and Time Format specifiers list.
Two formats are supported as overrides:
both dates as integer values, or
both dates as string values.
Example
Example using C# extension methods:
using System;
using WealthLab;
public class DBDates: WealthScript
{
protected override void Execute()
{
string begDate = "20040112";
string endDate = "20080125";
int iBegDate = 20040112;
int iEndDate = 20080125;
PrintDebug( begDate.DaysBetweenDates( endDate ) );
PrintDebug( iBegDate.DaysBetweenDates( iEndDate ) );
}
}
Legacy syntax example:
using System;
using WealthLab;
using Community.Components; // DaysBetweenDates here
/*** Requires installation of Community.Components Extension from www.wealth-lab.com > Extensions ***/
public class DBDates: WealthScript
{
protected override void Execute()
{
// Create an instance of class that holds the method
Calculate calc = new Calculate(this); // pass WealthScript as "this"
string begDate = "20040112";
string endDate = "20080125";
int iBegDate = 20040112;
int iEndDate = 20080125;
PrintDebug( calc.DaysBetweenDates( begDate, endDate ) );
PrintDebug( calc.DaysBetweenDates( iBegDate, iEndDate ) );
}
}