Export of Date Fields

[Tony Ramirez]

I want a date to export in a CDF format that I will be able to put a zero in
front of the date. I have managed to convert date fields over to numbers but
it only works for months with two digits. For instance 120404 works just
great - I did have to use conversion tables to make the date export like
this, but when I try to write 010104 it defaults back to 10104. In excel you
can make a custom format in the cell, but I dont see it anywhere in access.
The program that I am importing the data to needs to see the number as 010104
and not 10104. Thanks for any help.

 

[Jim/Chris]

Instead of using the format "Short Date" type mmddyy. In
your export make sure you check the "Save Formatted" box

Jim

 

[Tony Ramirez]

I want the field to be a text format not a date field....the other database
is waiting for the text file to write the date as "010105". So really it
doesnt have much to do with the date, as I can convert that, its just that
when its a text field Access drops the "0" leaving me "10105". Please help me.

 

[Tony Ramirez]

I guess I got it...dont know why it was giving me a hard time before, and now
it isnt. Thanks for your help.

 

[Ken Snell [MVP]]

Use a calculated field:

MyOutputField: Format([MyOrginalDateField], "mmddyy")