Calculation of Quarter Date

Question

0.00/5 (No votes)

See more:

how to calculate the quarter of the year from the starting date to Next Date like first Quarter is Start from April to June so the first date of quarter and the Last Date of Quarter

Please help.
thanks in advance.

Posted 22-Oct-10 18:29pm

NKBajaj

Updated 22-Oct-10 18:46pm

v2

Add a Solution

Comments

shakil0304003 23-Oct-10 2:55am

Your requirement is little bit confusing. Clear it what you want?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

saransaki08 · Answer 1 · 2010-10-22T18:50:00

Solution 1

Hi

i didnt check this code, pls check this code..

int GetQuarterName(DateTime myDate)
{
    return Math.Ceiling(myDate.Month / 3);
}
DateTime GetQuarterStartingDate(DateTime myDate)
{
    return new DateTime(myDate.Year,(3*GetQuarterName(myDate))-2,1);
}

Posted 22-Oct-10 18:50pm

saransaki08

Updated 22-Oct-10 20:20pm

v2

Comments

Hiren solanki 23-Oct-10 2:20am

added 'pre' tags for code visibility.

Jani Giannoudis · Answer 2 · 2011-03-18T13:08:00

To calculate the quarter based on the month April, you can use the Time Period Library for .NET:

C#

// ----------------------------------------------------------------------
public static void ShowQuarterInfo()
{
  ShowQuarterInfo( DateTime.Now );
} // ShowQuarterInfo

// ----------------------------------------------------------------------
public static void ShowQuarterInfo( DateTime moment )
{
  // set start month to April
  TimeCalendar calendar = new TimeCalendar(
    new TimeCalendarConfig { YearBaseMonth = YearMonth.April } );

  // working quarter
  Quarter quarter = new Quarter( moment, calendar );
  Console.WriteLine( "Quarter start: " + quarter.FirstDayStart );
  Console.WriteLine( "Quarter end: " + quarter.LastDayStart );

  // previous quarter
  Quarter previousQuarter = quarter.GetPreviousQuarter();
  Console.WriteLine( "Previous Quarter start: " + previousQuarter.FirstDayStart );
  Console.WriteLine( "Previous Quarter end: " + previousQuarter.LastDayStart );

  // next quarter
  Quarter nextQuarter = quarter.GetNextQuarter();
  Console.WriteLine( "Next Quarter start: " + nextQuarter.FirstDayStart );
  Console.WriteLine( "Next Quarter end: " + nextQuarter.LastDayStart );
} // ShowQuarterInfo

See also this[^] question/answer.

You will find more samples in the article Time Period Library for .NET[^].

Cheers, Jani.

shakil0304003 · Answer 3 · 2010-10-22T20:53:00

Example:

private void make(int year, int quarter)
        {
            DateTime starting, ending;
            int month = (4 + 3 * (quarter - 1)) % 12;

            starting = new DateTime(year, month, 1);
            ending = starting.AddMonths(3).AddDays(-1);
            MessageBox.Show(starting.ToString() + "," + ending.ToString());
        }

            make(2010, 1);
            make(2010, 2);
            make(2010, 3);
            make(2010, 4);

Calculation of Quarter Date

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0