473,598 Members | 3,096 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with "dates" using TransferText

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

Sep 23 '07 #1
5 2110
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
Sep 24 '07 #2
On Sep 23, 11:25 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
On Sun, 23 Sep 2007 15:16:53 -0700, Dave <i...@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- 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

Sep 24 '07 #3
On Sep 23, 6:16 pm, Dave <i...@songindex .orgwrote:
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.

Sep 24 '07 #4
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(dteM onth + 100), 2) & _
"-" & right(CStr(dteD ay + 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.
Sep 24 '07 #5
On Sep 23, 11:25 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
On Sun, 23 Sep 2007 15:16:53 -0700, Dave <i...@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- Hide quoted text -

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

Dave

Sep 25 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3283
by: Fons Dijkstra | last post by:
Hello, I'm using the mx.ODBC.Windows package in order to read/write a MSAccess database. Everything works fine apart from the DATE format handling. I'm using the default "datetimeformat" (i.e. DATETIME_DATETIMEFORMAT) as suggested. The date columns in the MSAccess database have "Short Date" format. When I read a DATE item everything works fine, like:
6
2450
by: Bill R via AccessMonster.com | last post by:
I have a query: SELECT tblCalendar.CalendarDay AS LastSunday FROM tblCalendar WHERE (((tblCalendar.CalendarDay)>=(Now()-7) And (tblCalendar.CalendarDay) <DateAdd("d",8-Weekday((Now()-7),2),(Now()-7))) AND ((tblCalendar.Weekday)=1)) ; tblCalendar is a table of consecutive dates from 1998 thru 2020. It has proven useful in many applications. CalendarDay is the date. The code above
3
18080
by: George | last post by:
Can someone tell me how to calculate the number of weeks between two dates. Your help is appreciated. Thanks, George
13
10688
by: Jim Armstrong | last post by:
Hi all - This problem has been driving me crazy, and I'm hoping the answer is something stupid I am neglecting to see.... The procedure posted below is part of an Access/SQL database I have developed. Basically, the user would input a beginning and ending date, and the query goes and pulls records that meet the following criteria: 1. TradeDate is between beginning date and ending date
4
1476
by: Yotam | last post by:
Hi, I need some help with JS. I will be grateful, if you can help me out. I have two date fields (check in, check out) and "number of days" field. I want the script to calculate automatically the difference. For example: I have defaults dates, and I want the script to put the difference in "number of days" field. And if the user will change the date, the number of days will change automatically.
4
2342
by: cheryl | last post by:
I am using the PHP.MYSQL and Apache server application in developing my website. I have problem in comparing dates. Website has room reservation, the user will check first the room availability. The user will input dates using the combo box like cboyear,cboday and cbomonth. What SQL statement or quey should I write to compare it to the database. The database has already have value in dates. I want to compare the input date to the database.......
9
21377
by: clintonb | last post by:
I'm looking for a way to calculate the number of days between two dates using standard C++ functions. Would it be as simple as just using the difftime() function and then dividing that result by the number of seconds in a day? - Clint
1
1324
by: Iyhamid | last post by:
Hi Every: Me Again.. still not finsh from same Project.. now I am in my last Problem.. I think anyway.. What I am trying to do is to get records between 2 dates in a combo box.. combo0 and combo1, both get there information from the same column.. Regards.. iehab
14
15306
by: | last post by:
Hi, I program in asp.net. I have a date in TextBox in format "dd/MM/yyyy". I would like to validate if the date is realy correct. I used RegularExpressionValidator with ValidationExpression="//", but user can write date "31/02/2000" and validator says that it is correct (everybody know that Febuary has 28 or 29 days).
0
8393
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8048
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8263
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5848
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5438
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3896
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3939
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2411
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1503
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.