Convert date to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
Back
Top