Re: Convert Numeric field to Date field

Tech-Archive recommends: Fix windows errors by optimizing your registry

"DorkyGrin" <DorkyGrin@xxxxxxxxx> wrote in message
news:1169169137.628134.128380@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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?

d=51217
?format$(cdate(format$(20000000+d,"0000-00-00")),"mm/dd/yyyy")


--
Reply to the group so all can participate
VB.Net: "Fool me once..."

.

Relevant Pages

  • Re: Access Replication
    ... replicate a database has a numeric field called "Status". ... MsysExchangeLog is a local table that records the synchs that have ...
    (microsoft.public.access.tablesdbdesign)
  • Re: heap memory
    ... I have a JDBC interface to an Oracle database. ... so a "select count" not solve my trouble. ... I can exctract 50000 rows with only a numeric field (and this works ... change it to instead process it as a stream of rows! ...
    (comp.lang.java.programmer)
  • Re: need to update a querie
    ... Compact the database first, just in case there's free space available. ... Try adding a new numeric field to your table, then using an Update query to ...
    (microsoft.public.access.gettingstarted)
  • RE: replace in a query
    ... A backup of the database would be a wise thing to do before attempting ... I would maybe suggest a slight variation on Phil's solution, ... you could create a new numeric field and set that to the numeric value ...
    (microsoft.public.access.queries)
  • Re: Strange Error
    ... records from the database by identifying the "Key" column in Access. ... identifying a numeric field. ... I have since changed the value of sSQL to: ... >> which should call ActivePDF Toolkit to generate a PDF from the related ...
    (microsoft.public.inetserver.asp.db)