Accountant Forums


Reply
Thread Tools

QIF import - wrong date format

 
 
Nicholas Latham
Guest
Posts: n/a
Thanked:
 
      03-13-2007, 10:29 PM
I'm a UK user trying to convert from Quicken 98 Deluxe to Money 2005. I've
been unable to convert directly - tried all the tips from Glyn Simpson's
site http://money.mvps.org, except converting via Money 2002 as I can't get
hold of a trial copy. As a result, I decided to resort to exporting my
Quicken accounts as QIF and importing to Money.

My transactions are fairly straightforward - no shares/unit trusts etc - and
it's imported most of the data OK. The one thing it's really struggling
with is the date. Most of the transactions are missing a date and when it
does translate, it imports in US format (mm/dd/yyyy).

I've gone in and looked at the structure of the QIF file and it looks as if
the date format in the file itself is US format. All of my PC settings are
UK and I can't see anywhere in Quicken that will affect the format of the
export.

Firstly, has anyone handled this already - is there an off-the-peg solution
out there?

Secondly, if not, I'm thinking that if I change my system settings to US
date format before importing to Money, then change my settings back
afterwards, any ideas if this would fix it?

I'm packing in for the evening but if anyone's got an answer that would help
me out I'd really appreciate it.


 
Reply With Quote
 
 
 
 
BrianW
Guest
Posts: n/a
Thanked:
 
      03-13-2007, 11:23 PM
Nicholas Latham wrote:
> I'm a UK user trying to convert from Quicken 98 Deluxe to Money 2005. I've
> been unable to convert directly - tried all the tips from Glyn Simpson's
> site http://money.mvps.org, except converting via Money 2002 as I can't get
> hold of a trial copy. As a result, I decided to resort to exporting my
> Quicken accounts as QIF and importing to Money.
>
> My transactions are fairly straightforward - no shares/unit trusts etc - and
> it's imported most of the data OK. The one thing it's really struggling
> with is the date. Most of the transactions are missing a date and when it
> does translate, it imports in US format (mm/dd/yyyy).
>
> I've gone in and looked at the structure of the QIF file and it looks as if
> the date format in the file itself is US format. All of my PC settings are
> UK and I can't see anywhere in Quicken that will affect the format of the
> export.
>
> Firstly, has anyone handled this already - is there an off-the-peg solution
> out there?
>
> Secondly, if not, I'm thinking that if I change my system settings to US
> date format before importing to Money, then change my settings back
> afterwards, any ideas if this would fix it?
>
> I'm packing in for the evening but if anyone's got an answer that would help
> me out I'd really appreciate it.


Not helpful I'm afraid. I tried and failed miserably to convert Q98 to
M2005, despite considerable assistance from Glyn.

If you can do better, all the best!

--
Brian
 
Reply With Quote
 
 
 
 
Glyn Simpson, MVP
Guest
Posts: n/a
Thanked:
 
      03-14-2007, 12:38 AM
Hi, I'm out of the country at the moment, but when I get back at the end of
the weekend, I;ll help you out. Your email arrived just after I left, so my
apologies I haven't had the chance to respond to you here.

--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org

See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx

I do not respond to any unsolicited email regarding Money

"Nicholas Latham" <(E-Mail Removed)> wrote in message
news:%236e5$(E-Mail Removed)...
> I'm a UK user trying to convert from Quicken 98 Deluxe to Money 2005.
> I've been unable to convert directly - tried all the tips from Glyn
> Simpson's site http://money.mvps.org, except converting via Money 2002 as
> I can't get hold of a trial copy. As a result, I decided to resort to
> exporting my Quicken accounts as QIF and importing to Money.
>
> My transactions are fairly straightforward - no shares/unit trusts etc -
> and it's imported most of the data OK. The one thing it's really
> struggling with is the date. Most of the transactions are missing a date
> and when it does translate, it imports in US format (mm/dd/yyyy).
>
> I've gone in and looked at the structure of the QIF file and it looks as
> if the date format in the file itself is US format. All of my PC settings
> are UK and I can't see anywhere in Quicken that will affect the format of
> the export.
>
> Firstly, has anyone handled this already - is there an off-the-peg
> solution out there?
>
> Secondly, if not, I'm thinking that if I change my system settings to US
> date format before importing to Money, then change my settings back
> afterwards, any ideas if this would fix it?
>
> I'm packing in for the evening but if anyone's got an answer that would
> help me out I'd really appreciate it.
>


 
Reply With Quote
 
Nicholas Latham
Guest
Posts: n/a
Thanked:
 
      03-14-2007, 07:22 PM
Glyn, Brian,

Thanks for your support, but I've managed to solve it myself. My second
thought below turned out to be a good one - worked like a charm! I've got
some warnings about invalid values during the import, although the account
balances all agree back to Quicken, so I'll have to investigate to find why.
There'll also be some expenses with unassigned categories or category
re-alignment that I'll need to do, but at least I don't have to manually
input 10,000+ dates by hand in order to recover my file completely!!! Like
that would have happened.... ;-)

In the meantime, I seem to have a file that I can sort out with a reasonable
amount of effort and continue to use, which was the point of buying Money in
the first place.

Happy accounting!

"Glyn Simpson, MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, I'm out of the country at the moment, but when I get back at the end
> of the weekend, I;ll help you out. Your email arrived just after I left,
> so my apologies I haven't had the chance to respond to you here.
>
> --
> Glyn Simpson, Microsoft MVP - Money
> http://money.mvps.org
>
> See http://money.mvps.org/faq/default.aspx for tips and fixes for MS
> Money.
> To send Microsoft your product wishes see
> http://money.mvps.org/wishes.aspx
>
> I do not respond to any unsolicited email regarding Money
>
> "Nicholas Latham" <(E-Mail Removed)> wrote in message
> news:%236e5$(E-Mail Removed)...
>> I'm a UK user trying to convert from Quicken 98 Deluxe to Money 2005.
>> I've been unable to convert directly - tried all the tips from Glyn
>> Simpson's site http://money.mvps.org, except converting via Money 2002 as
>> I can't get hold of a trial copy. As a result, I decided to resort to
>> exporting my Quicken accounts as QIF and importing to Money.
>>
>> My transactions are fairly straightforward - no shares/unit trusts etc -
>> and it's imported most of the data OK. The one thing it's really
>> struggling with is the date. Most of the transactions are missing a date
>> and when it does translate, it imports in US format (mm/dd/yyyy).
>>
>> I've gone in and looked at the structure of the QIF file and it looks as
>> if the date format in the file itself is US format. All of my PC
>> settings are UK and I can't see anywhere in Quicken that will affect the
>> format of the export.
>>
>> Firstly, has anyone handled this already - is there an off-the-peg
>> solution out there?
>>
>> Secondly, if not, I'm thinking that if I change my system settings to US
>> date format before importing to Money, then change my settings back
>> afterwards, any ideas if this would fix it?
>>
>> I'm packing in for the evening but if anyone's got an answer that would
>> help me out I'd really appreciate it.
>>

>



 
Reply With Quote
 
 
 
Reply

Thread Tools

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 On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Money 2007 -- QIF import - date format (not regional settings prob hisplaceresort Microsoft Money 3 12-29-2006 06:54 PM
Date format in MS Money and Quicken QIF files are different. Conversion? David Arnstein Microsoft Money 3 01-09-2005 11:42 PM
Date format in MS Money and Quicken QIF files are different. Conversion? David Arnstein Quicken 1 01-07-2005 05:33 PM
Conversion from .csv format to .qif format Dave Microsoft Money 2 07-21-2004 02:10 AM
QIF file date format adjustment? KenV Quicken 7 01-16-2004 05:19 PM


All times are GMT. The time now is 07:54 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.