Removing date / delimiters from fields

[sqleptical]

I'm using Access 97. I need to create an output that includes a date mmddyy record without the slashes (mm/dd/yy). I've been using Textpad's replace feature on the output, (replacing all "/" with "&quot - which works, but I know their has to be a better way. Does anyone know a sql statement or date format trick in Access to do this?

 

[JimHorton]

How about Format([yourDate],"mmddyyyy&quot...
--Jim

 

[sqleptical]

I tried typing mmddyy (with and w/o brackets) in the format field under a data type of Date/Time since Access does not offer this option in the format combo box. After saving the table and typing in a date in that format, I get an Access error; "The value you entered isn't valid for this field." I also tried unsuccesfully with that date format change using FoxPro 6.

 

[JimHorton]

The solution, mmddyyyy, should work in a tabless format section, or in a query. I just tried it in the table's format, without quotes or brackets, and it worked fine. If you do it in a query, just put the syntax in my first response in the Field row of the query grid.
--Jim