Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 10-17-2003, 07:18 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Date problems

In microsoft.public.money, Louise Chain wrote:

- quote -

> Money 2003 Version 11.0
> When downloading files from the Bank the downlaod is
> unable to download files after 10/10/03, and keeps
> replicating the files prior to 10/10/03. Error message:
> "A transaction in the QIF file has a date that could not
> be resolced and therefore was not recorded into your
> Money file"
> The system date in the Control Panel is correctly set for
> Australia
> The reports module only includes transactions after
> 10/10/03.


One possibility is that the QIF file uses mm/dd/yyyy or mm/dd/yy
data where your computer is set up for dd/mm/yyyy. In that case, you
could identify the problem and then seek out a program to permutate
the date, or change the setup on your computer temporarily. It
surely exists readily or could be cobbled together easily.

Perhaps the problem is a bad transaction that only happens to occur
near the 13th of October. In that case, I would make a copy of your
Money file. Make a copy of the .qif file that contains the problem
area. Remove perhaps half of the transactions from the copy of the
..qif using a text editor such as notepad. A transaction is the area
bounded by lines that contain only the "^" character. If you
succeed, the problem was in one of the transactions you removed. Use
a binary search processes to find the bad transaction and remove or
repair it.

For examples of what Money would like to see in a .qif file, do
File-> Export. Note that Money will accept the year with more than
one way. xx/xx/2003 could also be xx/xx/03 or xx/xx'03 .


 
Old 10-17-2003, 06:51 AM
Glyn Simpson, MVP
Guest
 
Posts: n/a
Default Re: Date problems

It depends on what is in the QIF file, but try setting the dates on your
system to use US dates and see whether the import works - it could be being
sent as a US date in the download.

--
Glyn Simpson, Microsoft MVP - Money

Check http://support.microsoft.com/default...d=fh;EN-GB;mny
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email mnyukwsh[at]microsoft.com especially if it's a UK specific wish.

I do not respond to any unsolicited email regarding Money
"Louise Chain" <ketting[at]bigpond.com> wrote in message
news:086101c39472$de26e760$a301280a[at]phx.gbl...
- quote -

> Money 2003 Version 11.0
> When downloading files from the Bank the downlaod is
> unable to download files after 10/10/03, and keeps
> replicating the files prior to 10/10/03. Error message:
> "A transaction in the QIF file has a date that could not
> be resolced and therefore was not recorded into your
> Money file"
> The system date in the Control Panel is correctly set for
> Australia
> The reports module only includes transactions after
> 10/10/03.



  #-1  
Old 10-17-2003, 05:52 AM
Louise Chain
Guest
 
Posts: n/a
Default Date problems

Money 2003 Version 11.0
When downloading files from the Bank the downlaod is
unable to download files after 10/10/03, and keeps
replicating the files prior to 10/10/03. Error message:
"A transaction in the QIF file has a date that could not
be resolced and therefore was not recorded into your
Money file"
The system date in the Control Panel is correctly set for
Australia

The reports module only includes transactions after
10/10/03.
 

Tags
date, problems
Similar Threads
Thread Forum Replies Last Post
Date Format
Philip: How do you change the date format (ie. day-month-year to month-day-year) in Money?
Microsoft Money 3 10-03-2003 01:06 PM
Billpay Date problems
Ion Control: BillPay seems to take an incredibly long time to pay bills. For instance, I tried to pay a bill last Wednesday and the earliest date payment could...
Microsoft Money 3 08-08-2003 03:19 AM
date format
rufus: Hi Can someone tell me how to change the date format in Money 98. I live in Australia and we write the date DD/MM/YY not MM/DD/YY. thanks rufus
Microsoft Money 1 07-07-2003 12:00 AM
Displaying date
Bill Irving: I have never been able to get Money to display the date formated as 23 Jul 2003 or Jul 23 2003 in check register or printing on any check's. Any...
Microsoft Money 1 07-05-2003 07:14 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:23 AM.