.net – How to convert an Excel serial date number to a .NET DateTime

.netdatetimeexcel

How do I convert from excel serial date to a .NET date time?

For example 39938 is 05/05/2009.

Best Solution

I find it simpler using FromOADate method, for example:

DateTime dt = DateTime.FromOADate(39938);

Using this code dt is "05/05/2009".

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

An easy to understand and simple solution.

// Save today's date.
var today = DateTime.Today;

// Calculate the age.
var age = today.Year - birthdate.Year;

// Go back to the year in which the person was born in case of a leap year
if (birthdate.Date > today.AddYears(-age)) age--;

However, this assumes you are looking for the western idea of the age and not using East Asian reckoning.

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Best Solution

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

Sql – How to return only the Date from a SQL Server DateTime datatype

Related Question