Convert Date to String

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

Guest

I need to convert a Date field to a string. Additionally, the string needs
to be in "mmddyyyy" format. How do I do this? I'm especially concerned
regarding dates where the month and day are only one character, e.g.,
"1/1/2007". Thanks.

Ken
 
By String I presume you mean June 2, 2007. You can set the format of the
Date field in your table if you want it to display the same everywhere in
the database. If you only want the String in a certain form or report, set
the format of your Date field in the textbox on the form or report.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

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

Converting Number to Date 3
Convert string to date 4
How to convert decimal year to date format in excel 2
Special string convertion to date and time 4
Special converting of string date&time to date format 3
MM/DD/YYYY appears as time when using update query 1
Convert Date string to date format 7
Converting Text to Date 3

Back
Top