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