find date in c# based on passed parameters

Question

0.00/5 (No votes)

See more:

Hi,
given the year as int i.e. 2012 and the month as text i.e. "january"
how do I find the last monday of the previous month?
Thanks

Posted 12-Jun-12 22:59pm

arkiboys

Add a Solution

2 solutions

Solution 1

Something like this:

C#

FindDate(2012, "January", DayOfWeek.Monday);

C#

public static DateTime FindDate(int year, string month, DayOfWeek day)
       {
           DateTime lastDay = new DateTime(year, DateTime.ParseExact(month, "MMMM", CultureInfo.CurrentCulture).Month, 1).AddMonths(1).AddDays(-1);
           DayOfWeek lastDow = lastDay.DayOfWeek;
           int diff = day - lastDow;

           return lastDay.AddDays(diff).Date;
       }

Posted 12-Jun-12 23:09pm

Manas Bhardwaj

Comments

Prasad_Kulkarni 13-Jun-12 5:18am

5'ed!

arkiboys 13-Jun-12 5:33am

thank you

VJ Reddy 13-Jun-12 8:20am

The above code gives the date as 30/1/2012. I think the
.AddMonths(1).AddDays(-1); in the FindDate method is to be
.AddDays(-1);
If so then it returns 26/12/2011, which is correct.

It works fine when the required day of the week is before the DayOfWeek of the last day of month as in the above case. But, when the required day of week is after the day of week of the last day of month, then the correct date is not obtained
for eg. if we use
FindDate(2012, "February", DayOfWeek.Thursday);
it returns
2/2/2012 whereas the correct date is 26/1/2012

I have used another alternative.

Please see my solution.

Thank you.

Manas Bhardwaj 13-Jun-12 9:09am

Thanks for pointing out!

VJ Reddy 13-Jun-12 12:55pm

Thank you, Manas, for the response :)

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)

VJ Reddy · Accepted Answer · 2012-06-13T02:14:00

The following code can be used to find required last day of the previous month

C#

void Main()
{
    DateTime date = LastDayOfPreviousMonth(2012, "January", DayOfWeek.Monday);
    Console.WriteLine (date);
    
    //date
    //26/12/2011
}
    
public DateTime LastDayOfPreviousMonth(int year, string month, DayOfWeek dayOfWeek){
    int monthNo = Array.IndexOf(System.Globalization.CultureInfo
			.InvariantCulture.DateTimeFormat.MonthNames, month)+1;
    DateTime lastDateOfPrevMonth = new DateTime(year, monthNo,1).AddDays(-1);
    							 
    return lastDateOfPrevMonth.AddDays(lastDateOfPrevMonth.DayOfWeek < dayOfWeek ? 
    			dayOfWeek - lastDateOfPrevMonth.DayOfWeek -  7 : 
    			dayOfWeek - lastDateOfPrevMonth.DayOfWeek);
}