how to get the month name

Question

    using (DataAccessAdapter adapter = new DataAccessAdapter())
       {
         LinqMetaData meta = new LinqMetaData(adapter);
         var datas = (from x in meta.Table
           where x.DateCreated >= startDate && x.DateCreated <= endDate && x.ViaTo > 0 && !x.Cancelled
           group x by new { month = x.DateCreated.Value.Month } into g
           select new
           {
            MonthNr = g.Key,
            //MonthName = ?
            TotalMonthAmount = g.Sum(x => x.Amount)
            });
.....
       }

And startDate & endDate are valid Dates.

I only get the month number, how to get the month name for the DateCreated?

possible duplicate of [how to get complete month name from DateTime](http://stackoverflow.com/questions/6765441/how-to-get-complete-month-name-from-datetime) — BCdotWEB, Apr 08 '15 at 11:10

score 4 · Accepted Answer · answered Apr 08 '15 at 11:12

4

You can get the month name using this function:

CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(monthNumber);

answered Apr 08 '15 at 11:12

Richard

21,728
13
62
101

Where monthNumber is MonthNr ? ( in my case ) – Florin M. Apr 08 '15 at 11:14
I believe it is g.Key – Richard Apr 08 '15 at 11:23

score 0 · Answer 2 · answered Apr 08 '15 at 11:10

0

new { month = x.DateCreated.Value.Month.ToString("MMM") }

answered Apr 08 '15 at 11:10

Lali

2,816
4
30
47

score 0 · Answer 3 · answered Apr 08 '15 at 11:11

I think you are asking about Month property. Check this:

using System;

class Program
{
    static void Main()
    {
        DateTime now = DateTime.Now;
        //
        // Write the month integer and then the three-letter month.
        //
        Console.WriteLine(now.Month); //outputs 5
        Console.WriteLine(now.ToString("MMM")); //outputs May
    }
}

how to get the month name

3 Answers3