Problem with "dates" using TransferText

[Dave]

Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave

[Tom van Stiphout]

On Sun, 23 Sep 2007 15:16:53 -0700, Dave <in**@songindex.orgwrote:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.

>Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave

[Dave]

On Sep 23, 11:25 pm, Tom van Stiphout <[e-mail]:

On Sun, 23 Sep 2007 15:16:53 -0700, Dave <[e-mail]:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.

Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave- Hide quoted text -

- Show quoted text -

She sent me her output of the file and when I open it in Notepad the
formatting is how she described (i.e., the dates are different from
when I create the output file).

It could be that she modified it in Excel first and re-saved it as a
text file, then maybe that is how things could have changed. I will
ask today.

Otherwise any other ideas are welcome....

Thanks
Dave

[lyle]

On Sep 23, 6:16 pm, Dave <[e-mail]:

Thanks for any help you can provide.

If I were doing this I would use a regular expression to translate
strings in the form of
99/99/9999 or 99/99/99 to dates that everyone could understand:
9999-99-99.

And if I weren't so busy right now I'd "right" one because it might be
useful to have in the old repertoire. Of course, such an animal may be
lurking on the net.

[Michael Gramelspacher]

Indeed. Is this it?

'-------------------------------------------------------
Function IsoDate(dteDate)
'-------------------------------------------------------
'Version 1.0 by Giuliano Sauro
If IsDate(dteDate) = True Then
Dim dteDay, dteMonth, dteYear
dteDay = Day(dteDate)
dteMonth = Month(dteDate)
dteYear = Year(dteDate)
IsoDate = dteYear & _
"-" & right(CStr(dteMonth + 100), 2) & _
"-" & right(CStr(dteDay + 100), 2)
Else
IsoDate = Null
End If
End Function
On Mon, 24 Sep 2007 13:37:30 -0000, lyle <ly************@gmail.com>
wrote:

>Of course, such an animal may be
lurking on the net.

[Dave]

On Sep 23, 11:25 pm, Tom van Stiphout <[e-mail]:

On Sun, 23 Sep 2007 15:16:53 -0700, Dave <[e-mail]:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.

Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave- Hide quoted text -

- Show quoted text -

Hi Tom, so I think that you are probably right re: Excel. Thanks for
the suggestion.

Dave