Sign in
 
Visual Basic > Visual Basic Forums > Visual Basic Language > Excel Serial date conversion
Ask a questionAsk a question
Search Forums:
 

AnswerExcel Serial date conversion

  • Thursday, November 30, 2006 4:17 PMCoroebus Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hello,

    how to convert an excel serial date as 39051,4387847222 in a datetime as 30/11/06 10:31:51 2549 using vb.net?

    thanks

     

Answers

  • Thursday, November 30, 2006 4:29 PMDMan1ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Dim d As Date = Date.FromOADate(39051.4387847222)

    MessageBox.Show(d.ToString)

     

All Replies

  • Thursday, November 30, 2006 4:29 PMDMan1ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Dim d As Date = Date.FromOADate(39051.4387847222)

    MessageBox.Show(d.ToString)