Date Formats

  • Thread starter Thread starter Kholl3
  • Start date Start date
K

Kholl3

I loose the format of the field I am pasting from. A date field with a
format mask of mm/dd/yyy shows as 05/03/2005. When pasting this column or
field to a text field, it reverts to 5/3/2005. How does one preserve the
leading zeros? When exporting a date field to a text file, unwanted hours,
minutes and seconds are exported as well when the field type is set to Date
even with the format mask. The final result needed will always contain the
leading zeros with no further breakdown of time.
Are there setup factors I am missing?
 
Kholl3 said:
I loose the format of the field I am pasting from. A date field with a format
mask of mm/dd/yyy shows as 05/03/2005. When pasting this column or field to a
text field, it reverts to 5/3/2005. How does one preserve the
leading zeros? When exporting a date field to a text file, unwanted hours,
minutes and seconds are exported as well when the field type is set to Date
even with the format mask. The final result needed will always contain the
leading zeros with no further breakdown of time.
Are there setup factors I am missing?
Click to expand...

Formatting of dates is a display property only. It has no effect on what is
*stored*. If you want a specific format when exporting you need to export a
query (not the table) and use the format function to provide the output you
want.
 
Back
Top