Date format exporting in 2000

  • Thread starter Thread starter shoobootie
  • Start date Start date
S

shoobootie

Win XP (and Win 98) and Access 2000

OK, I import text from a comma-delimited text file to a
table I already have created. In the text file, there is
a date field that is formatted as mm/dd/yyyy. I have my
table in Access set up to convert the date to mm/yy/yyyy
(don't ask, it has to be this way). The conversion works
beautifully as 08/01/2006 becomes 08/06/2006.

Now the problem...I need to export the data to a text
file with the mm/yy/yyyy format. It seems Access
doesn't "really" convert the data, rather it shows in my
table as mm/yy/yyyy but exports as the original
mm/dd/yyyy.

Further, if I click in the date field, the value reverts
back to 8/1/2006. When I click off of the field,
everything is good again.

Further yet, when I export, Access tacks on a timestamp
of 0:00:00. This completely screws up my big picture
process.

I'm not crazy, this used to work. I have 10,000 ID badges
printed as proof that this used to not be a problem.

Aaack! How do I convince Access that I really want
mm/yy/yyyy in my export? How do I get rid of the
timestamp?

Internet beers to whoever has the answer! Thanks.
 
shoobootie said:
Win XP (and Win 98) and Access 2000

OK, I import text from a comma-delimited text file to a
table I already have created. In the text file, there is
a date field that is formatted as mm/dd/yyyy. I have my
table in Access set up to convert the date to mm/yy/yyyy
(don't ask, it has to be this way). The conversion works
beautifully as 08/01/2006 becomes 08/06/2006.

Now the problem...I need to export the data to a text
file with the mm/yy/yyyy format. It seems Access
doesn't "really" convert the data, rather it shows in my
table as mm/yy/yyyy but exports as the original
mm/dd/yyyy.

Further, if I click in the date field, the value reverts
back to 8/1/2006. When I click off of the field,
everything is good again.

Further yet, when I export, Access tacks on a timestamp
of 0:00:00. This completely screws up my big picture
process.

I'm not crazy, this used to work. I have 10,000 ID badges
printed as proof that this used to not be a problem.

Aaack! How do I convince Access that I really want
mm/yy/yyyy in my export? How do I get rid of the
timestamp?
Click to expand...

Formatting of a DateTime field has zero effect on what is actually stored.

Build a query based on your table replacing the Date field with an expression
using the Format() function. That will output an actual string in the desired
format. Then you export the query instead of the table.
 
Back
Top