Re: Date conversion

The way we have it at our company is that the date format is like this: DD-MMM-YY Try the following statement:

return = Format(OracleDate,"mm/dd/yy")

davidd_at_pepstores.com

Chris Eastwood wrote:

> Check out the Oracle TODATE function. This may help you translate some of
> the date values. I'd suggest changing the column type myself.
>
> Regards
>
> Chris Eastwood
> Software Engineer
> ACNielsen Ltd
> bubba wrote in message <35cf8dc9.0_at_news.webt.com>...
> >I have an oracle 8 database with the date field as a char(8). (I dind't set
> >this up).
> >
> >the date is being displayed as '2434188' when I show it on a vb form.
> >
> >What kind of date form is this ?It doesn't look like julian? How can I
> >convert this to regular date formats like 01/01/98?
> >
> >Help please
> >
> >brittonb_at_webt.com
> >
> >
Received on Wed Aug 19 1998 - 00:00:00 CEST