Get all months names between two given dates

Question

0.00/5 (No votes)

See more:

Hi All

Here my problem is u want to find different month name with year ... how to get for ex

if i gave Nov-2015 to Jan-2016 mean i want to display
like

Nov-2015
Dec-2015
Jan-2016

how to get like this ... i get the datetime value from datetimepicker in windows applications.

Thanks

Posted 8-Jan-16 0:13am

prasanna.raj

Add a Solution

1 solution

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)

Andy Lanng · Accepted Answer · 2016-01-08T00:27:00

Solution 1

C#

var start = new DateTime(2013, 1, 1);
var end = new DateTime(2013, 6, 22);

// set end-date to end of month
end = new DateTime(end.Year, end.Month, DateTime.DaysInMonth(end.Year, end.Month));

var diff = Enumerable.Range(0, Int32.MaxValue)
                     .Select(e => start.AddMonths(e))
                     .TakeWhile(e => e <= end)
                     .Select(e => e.ToString("MMMM"));

do you google?[^]

Posted 8-Jan-16 0:27am

Andy Lanng

Comments

prasanna.raj 8-Jan-16 6:31am

where i can declare e ... showing error like can't declare e

Andy Lanng 8-Jan-16 6:32am

You will need to add the linq library reference

prasanna.raj 8-Jan-16 6:44am

i added linq library like this
1)In a Visual Basic or C# project, click the Project menu, and then click Add Reference.

2)In the Add Reference dialog box, click the .NET tab, scroll to System.Core.dll, and then click it. ...
3)Add a using directive or Imports statement for System.Linq to your source code file or project.

even though i got same error and i added linq namespace also ... what can i do ..

Andy Lanng 8-Jan-16 6:52am

oh! do you already have a variable named 'e'?

I tried it myself and it's fine with just using System; for the date types and using System.Linq; for the linq & lambda. If I remove the using System.Linq; then it complains about the Enumerable class before the the lambda

PS: By lambda, I mean the Func syntax: [param]=>[function] or e => e <= end
That says
"call the input parameter 'e'" (e=>)
"perform a boolean check 'e' is less than or equal to 'end'" (e <= end)

prasanna.raj 8-Jan-16 7:16am

i already use linq ... sorry am not get you clearly ...how can i change this

var diff = Enumerable.Range(0, Int32.MaxValue)
.Select(e => start.AddMonths(e))
.TakeWhile(e => e <= end)
.Select(e => e.ToString("MMMM"));

Andy Lanng 8-Jan-16 7:16am

Please post the entire method

prasanna.raj 8-Jan-16 8:05am

i got the date year like 01/Nov/2015 and 01/Dec/2015 and 01/Jan/2016 ... but how can i get into one variable ... i just check this as debug mode in diff -> non public members -> source -> result view option...

prasanna.raj 8-Jan-16 8:31am

got it thanks ...

Andy Lanng 8-Jan-16 8:32am

oh, cool - well done ^_^

Member 12224368 3-Jun-17 7:40am

Can you let me Know how to store the those months in db using ViewBag
Ex: ViewBag.months = diff;

in "diff" what ever values are there I want to save that data in one column.
Please let me know how I can do.

Thank You.