Convert date to text

J

Jim

I have a query that pulls a date from a table, which is stored as a short
date, i.e. 7/2/2005. I need to convert this date to a text string so that I
may import the query record into an Oracle database as MMDDYY. Any
suggestions will be helpful and appreciated.
 
M

Marshall Barton

Jim said:
I have a query that pulls a date from a table, which is stored as a short
date, i.e. 7/2/2005. I need to convert this date to a text string so that I
may import the query record into an Oracle database as MMDDYY. Any
suggestions will be helpful and appreciated.
Click to expand...


Actually, the date is stored as a Double type number.
ShortDate, LongDate,etc are just Formats.

You can use the Format function to convert a date to any
number of formatted strings> E.g.

Format(datefield, "mmddyy")
 
J

Jim

Marshall,

Thank you for your help. This did the trick. The help is much appreciated.
 
Top