Convert Date to String

K

Ken

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
 
S

Steve

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
[email protected]
 
Top