日期之间的季度计数

您的示例是错误的：4-Jan-2009和27-oct -2010 之间只有7个四分之一

您可以简单地在项目中添加对Microsoft.VisualBasic.dll的引用，并使用DateDiff:

VB:

Public Shared Function getQuartersBetween(ByVal d1 As Date, ByVal d2 As Date) As Int32
    Return DateDiff(DateInterval.Quarter, d1, d2)
End Function

C#：

public static int getQuartersBetween(System.DateTime d1, System.DateTime d2)
{
    return Microsoft.VisualBasic.DateAndTime.DateDiff(DateInterval.Quarter, d1, d2);
}

或者您可以编写自己的实现：

public class Quarter
{
    public static long GetQuarters(DateTime dt1, DateTime dt2) 
    { 
        double d1Quarter = GetQuarter(dt1.Month); 
        double d2Quarter = GetQuarter(dt2.Month); 
        double d1 = d2Quarter - d1Quarter; 
        double d2 = (4 * (dt2.Year - dt1.Year)); 
        return Round(d1 + d2); 
    } 
    private static int GetQuarter(int nMonth) 
    { 
        if (nMonth <= 3) 
            return 1; 
        if (nMonth <= 6) 
            return 2; 
        if (nMonth <= 9) 
            return 3; 
        return 4; 
    } 
    private static long Round(double dVal) 
    { 
        if (dVal >= 0) 
              return (long)Math.Floor(dVal); 
        return (long)Math.Ceiling(dVal); 
    } 
}

或在VB.NET:中

Public Class Quarter
    Public Shared Function GetQuarters(ByVal dt1 As DateTime, ByVal dt2 As DateTime) As Long
        Dim d1Quarter As Double = GetQuarter(dt1.Month)
        Dim d2Quarter As Double = GetQuarter(dt2.Month)
        Dim d1 As Double = d2Quarter - d1Quarter
        Dim d2 As Double = (4 * (dt2.Year - dt1.Year))
        Return Round(d1 + d2)
    End Function
    Private Shared Function GetQuarter(ByVal nMonth As Integer) As Integer
        If nMonth <= 3 Then
            Return 1
        End If
        If nMonth <= 6 Then
            Return 2
        End If
        If nMonth <= 9 Then
            Return 3
        End If
        Return 4
    End Function
    Private Shared Function Round(ByVal dVal As Double) As Long
        If dVal >= 0 Then
            Return CLng(Math.Floor(dVal))
        End If
        Return CLng(Math.Ceiling(dVal))
    End Function
End Class

为您编写的代码：尝试以下代码

 public static void Main()
    {
        //Application.Run(new XmlTreeDisplay());
        int monthdiuff = monthDifference(Convert.ToDateTime("01/04/09"), Convert.ToDateTime("10/27/10"));
        Console.WriteLine(monthdiuff);
        int totalQuater = (monthdiuff / 3) + (monthdiuff%3);
        Console.WriteLine(totalQuater);
        Console.ReadLine();
    }
    private static int monthDifference(DateTime startDate, DateTime endDate)
    {
        int monthsApart = 12 * (startDate.Year - endDate.Year) + startDate.Month - endDate.Month;
        return Math.Abs(monthsApart);
    }

如果没有一些代码可以查看，我无法帮助您找到确切的问题。

如果是我，我可能会找到日期之间的差异(以天为单位(，然后除以四分之一的天数(91天左右(。我相信C#有某种日期解析模块，它可以将日期作为字符串读取，给你两个对象，然后你可以减去它们，以找出天数的差异。

这是一种基于您的假设计算季度的粗略形式，您可以选择修改，因为它足够好

DateTime dt1 = new DateTime(2009, 1, 1);// new DateTime(2009, 6, 1);
DateTime dt2 = new DateTime(2010, 10, 27);// new DateTime(2011, 7, 18);
if (dt1.Month < 4)
  dt1 = new DateTime(dt1.Year,1,1);
else if (dt1.Month < 7)
  dt1 = new DateTime(dt1.Year,4,1);
else if (dt1.Month < 10)
  dt1 = new DateTime(dt1.Year,7,1);
else
  dt1 = new DateTime(dt1.Year,10,1);
if (dt2.Month < 4)
   dt2 = new DateTime(dt2.Year, 3, DateTime.DaysInMonth(dt2.Year, 3)); 
else if (dt2.Month < 7)
   dt2 = new DateTime(dt2.Year, 6, DateTime.DaysInMonth(dt2.Year, 6));
else if (dt2.Month < 10)
   dt2 = new DateTime(dt2.Year, 9, DateTime.DaysInMonth(dt2.Year, 9));
else
   dt2 = new DateTime(dt2.Year, 12, DateTime.DaysInMonth(dt2.Year, 12));
TimeSpan ts = dt2 - dt1;
int quarters = (int) ts.TotalDays/90;
Console.WriteLine(quarters);

我根据您的需要将日期定为季度开始和结束的基线，然后假设90天的季度将diff转换为int。对于您提到的示例，看看它是否足够适合您

如果季度的定义是90天的差异，当然很容易：

    internal static int GetNumberOfQuarters(DateTime p_DtStart, DateTime p_DtEnd)
    {
        TimeSpan span = p_DtEnd.Subtract(p_DtStart);
        return (int)span.TotalDays % 90;
    }

但这不是你想要的。这个呢(没有测试，但你会明白的(

internal static class DateTimeTools
{
    internal static int GetNumberOfQuartersBetweenDates(DateTime startDate, DateTime endDate)
    {
        int iYearStart, iYearEnd, iMonthStart, iMonthEnd, iDayStart, iDayEnd;
        iYearStart = startDate.Year;
        iYearEnd = endDate.Year;
        iMonthStart = startDate.Month;
        iMonthEnd = endDate.Month;
        iDayStart = startDate.Day;
        iDayEnd = endDate.Day;
        int iYearDiff, iQuarterDiff, iDayDiff;
        iYearDiff = iYearEnd - iYearStart;
        iQuarterDiff = iMonthEnd % 3 - iMonthStart % 3;
        iDayDiff = iDayEnd - iDayStart;
        int iNumOfQuarters = 0;
        // at least a year difference? 
        if ((iYearDiff > 0 && iQuarterDiff > 0) || iYearDiff > 0 && iQuarterDiff == 0 && iDayDiff >= 0)
        {
            iNumOfQuarters = iYearDiff * 4 + iQuarterDiff;
        }
        // at least a quarter difference?
        // within different years
        if ((iYearDiff > 0 && iQuarterDiff <= 0)) // eg, dec 2010 - feb 2011 iYearDiff 1 iQuarterDiff -3
        {
            if ((iQuarterDiff == -3 && iDayDiff >= 0) || iQuarterDiff > -3)
            {
                iNumOfQuarters = iQuarterDiff + 4;
            }
        }
        // within the same year
        if (iYearDiff == 0 && iQuarterDiff > 0)
        {
            if ((iQuarterDiff == 1 && iDayDiff >= 0) || iQuarterDiff > 1)
            {
                iNumOfQuarters = iQuarterDiff;
            }
        }
        return iNumOfQuarters;
    }
}

谨致问候，尼科

获取季度差异的简单公式：

{
    int firstQuarter = getQuarter(first);
    int secondQuarter = getQuarter(second);
    return 1 + Math.Abs(firstQuarter - secondQuarter);
}
private static int getQuarter(DateTime date)
{
    return (date.Year * 4) + ((date.Month - 1) / 3);
}