Export of Date Fields

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

Guest

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.
 
Instead of using the format "Short Date" type mmddyy. In
your export make sure you check the "Save Formatted" box

Jim
 
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.
 
I guess I got it...dont know why it was giving me a hard time before, and now
it isnt. Thanks for your help.
 
Back
Top