Convert Numeric field to Date field

I've got a situation where there is Numeric data coming into a program
from an older database. The field in question is a numeric field that
is returning this: "51217.00"

That number represents Dec 17, 2005.

Single digit months look like this: 40116.00 indicating Jan 16, 2004.

I need to convert that field into a new field that is defined as a DATE
field.

Ultimately, with the date field, I'd like it to be formatted like this:
12/17/2005

Anybody got any hints?

Thanks

DG

.

Relevant Pages

  • Re: YYYYMMDD
    ... > How can I validate a numeric data from database against this format ... Vbscript documentation is available here: ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: YYYYMMDD
    ... > How can I validate a numeric data from database against this format ... > four digit represents the year and the preceding 2 digits represents the ... DateOkay = False ...
    (microsoft.public.scripting.vbscript)
  • Re: Treating NULL database values in classes and Form fields.
    ... When I read numeric data from a database into a class object and then ... display the data on a Form what are the different ways out there for dealing ...
    (microsoft.public.vb.general.discussion)
  • Treating NULL database values in classes and Form fields.
    ... When I read numeric data from a database into a class object and then ... They can't be stored as DBNulls assuming I am using ...
    (microsoft.public.vb.general.discussion)
  • Re: YYYYMMDD
    ... > How can I validate a numeric data from database against this format ... > YYYYMMDD? ... > four digit represents the year and the preceding 2 digits represents the ...
    (microsoft.public.scripting.vbscript)