Convert date to text

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.
 
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")
 
G

Guest

Marshall,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Windows 7 I need to convert date to text 3
Convert String to Date 1
Convert text date to date/time 3
Convert and sort date originally formated as text 3
Format DATETIME to Date in query on linked table 4
Numeric Field Overflow when appending date - how to convert it to text 1
Convert Text to Date 4

Top