Question

How to convert integer dates from a string array to DateTime in C#

Answer 1

using System;

namespace ConsoleApplication_C_Sharp
{
    class Program
    {
        static void Main(string[] args)
        {
            var arr = new string[]
            {
                "35582", 
                "36126",
                "37982",
                "38621",
                "39871",
                "40571",
                "41877",
                "42753"
            };

            foreach (string s in arr)
            {
                double d = double.Parse(s);

                DateTime dt = DateTime.FromOADate(d);

                Console.WriteLine("{0} = {1}", s, dt.ToShortDateString());
            }
        }
    }
}

/*
run:
   
35582 = 01/06/1997
36126 = 27/11/1998
37982 = 27/12/2003
38621 = 26/09/2005
39871 = 27/02/2009
40571 = 28/01/2011
41877 = 26/08/2014
42753 = 18/01/2017

*/

 

70+ SQL courses for beginners and professionals