How to format date in Linq

Question

How to format date in Linq --------------------------

Hi,
I am working on a linq query. I want to format date column to 'Mm/dd/yy' format. But, the Linq query shows error that Linq doesn't support formatting. Any help?

Here is my code:

This is part of linq query.I am tring to format and concatinate two columns.

select new abc
                           {
                               cardDates = (cad.Key.SchStartDT.ToString("dd/MM/yyyy") + "-" + cad.Key.SchEndDT.ToString("dd/MM/yyyy"))
                           });

Please show your failing code. More often than not it is much easier to explain a fix to an existing solution than to explain a solution built from scratch. — Sergey Kalinichenko, Dec 17 '14 at 05:47
possible duplicate of [format date in linq query result](http://stackoverflow.com/questions/19778672/format-date-in-linq-query-result) — FoggyDay, Dec 17 '14 at 05:51
select new abc { cardDates = (cad.Key.SchStartDT.ToString("dd/MM/yyyy") + "-" + cad.Key.SchEndDT.ToString("dd/MM/yyyy")) }); — user3161958, Dec 17 '14 at 05:58

score 0 · Accepted Answer · edited May 23 '17 at 10:33

0

This code works for (LINQ to Objects case)

    public class Person
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public DateTime DateOfBirth { get; set; }
    }


    private static void Main(string[] args)
    {

        var people = new List<Person>
        {
            new Person
            {
               Id = 1,
               Name = "James",
               DateOfBirth = DateTime.Today.AddYears(-25),
            },

            new Person
            {
                Id = 2,
                Name = "John",
                DateOfBirth = DateTime.Today.AddYears(-20),
            },

            new Person
            {
               Id = 3,
               Name = "Peter",
               DateOfBirth = DateTime.Today.AddYears(-15),
            }
       };

       var result = people.Select(t => new
       {
           t.Name,
           DateStr = t.DateOfBirth.ToString("dd/MM/yyyy")
       }).Take(2).ToList();

       foreach (var r in result)
       {
          Console.WriteLine(r.Name);
          Console.WriteLine(r.DateStr);
       }

       Console.ReadLine();
}

For Linq to Entities case, check this answer Formatting date in Linq-to-Entities query causes exception

edited May 23 '17 at 10:33

Community

1
1

answered Dec 17 '14 at 05:48

Omar.Alani

4,050
2
20
31

plz check my code select new abc { cardDates = (cad.Key.SchStartDT.ToString("dd/MM/yyyy") + "-" + cad.Key.SchEndDT.ToString("dd/MM/yyyy")) }); – user3161958 Dec 17 '14 at 06:00
Is this select from LINQ to Entities (like Entity Framework) or LINQ to Objects (in Memory) ? – Omar.Alani Dec 17 '14 at 06:08
i got an error: : LINQ to Entities does not recognize the method 'System.String Format(System.String, System.Object)' method, and this method cannot be translated into a store expression. – user3161958 Dec 17 '14 at 06:44
oh sorry. I am using LINQ to Entities – user3161958 Dec 17 '14 at 06:44
Follow the link that I've updated the answer with. – Omar.Alani Dec 17 '14 at 07:25

How to format date in Linq

1 Answers1