convert excel date to asp date

[lyne_asp]

Please help me to convert excel date to asp date.

Here is my code


objConnEx.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Netroot\WebApp\testprograms\Shuttle_Serv ice\Attachment\BusRequest.xls;Extended Properties=Excel 8.0;HDR=Yes;IMEX=1;"
set objRS = server.createObject("ADODB.recordset")
SQL = "SELECT * from [BusRequest$]"
objRS.Open SQL,objConnEx, 1

Do until objRS.eof

Response.write(objRS.fields(0).Value)
// The value of this in excel is 06/29/2007


objRS.Movenext
Loop

The output of this script is
39336
How Can I convert 39336 to 6/29/2007?

Thanks


THanks

[justintaitt]

Hi,
You could probably try the FromOADate() function. The only thing was when I tried it with the value you supplied I was off by 74 days so I subtracted that. Not sure if it would be affected by leap years though.

 
        Dim myDate As DateTime
 
myDate = DateTime.FromOADate(39336 - 74)
 
Response.Write(myDate.ToString)

The 39336 would be replaced with a variable. Hope this helps.

[jhardman]

Hi,
You could probably try the FromOADate() function. The only thing was when I tried it with the value you supplied I was off by 74 days so I subtracted that. Not sure if it would be affected by leap years though.

I tried it in excel and I also got 9/11/07

Jared

[justintaitt]

I tried it in excel and I also got 9/11/07

Jared

I don't know then, I created a new website and tried that and it worked.

Forgive me for asking, but did you subtract the 74?