How to change a date to a double

[Wallabie]

Does anyone know how to change a date into a double?

I've used the DateTime.ToOADate and i can get the NOW and TODAY dates to convert to a double but i can't work out how to get a specific date,

EG:

1/6/2003 (thats 1st June, for those that use the US notion not 6th Jan)

Can anyone help?

[Excelsoft]

Try to use this:

    Dim d As Double
    Dim x As Integer
    x = InputBox("Enter", "Title", 12)
    d = CDbl(x)

[Wallabie]

hmmmm........, That looks like VB6 to me and wont work in .NET

After mucking around with it, changing the Integer to a Date.
It errors out with a "Converstion from Date to Double requires calling the Date.ToOADate method" which was what it was doing before. Like i said in the above post NOW and TODAY work ok but not a specific date.

[nemaroller]

Dim c As Date
         c = Convert.ToDateTime("01/06/03")
        Dim r As Integer
        MsgBox(c.ToString)
        r = c.ToOADate
        MsgBox(r.ToString)

[Wallabie]

That looks like it'll work nemaroller, i'll test it out and see.

Thanks

[Wallabie]

Yup! Worked, excellent.

Thank you very much nemaroller