QIF import - wrong date format

Discussion in 'Microsoft Money UK' started by Nicholas Latham, Mar 13, 2007.

  1. 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.
     
    Nicholas Latham, Mar 13, 2007
    #1
    1. Advertisements

  2. Nicholas Latham

    BrianW Guest

    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
     
    BrianW, Mar 13, 2007
    #2
    1. Advertisements

  3. 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" <> wrote in message
    news:%236e5$...
    > 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.
    >
     
    Glyn Simpson, MVP, Mar 14, 2007
    #3
  4. 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" <> wrote in message
    news:...
    > 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" <> wrote in message
    > news:%236e5$...
    >> 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.
    >>

    >
     
    Nicholas Latham, Mar 14, 2007
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. KenV
    Replies:
    7
    Views:
    1,642
    Joy & John Beurket
    Jan 16, 2004
  2. David Arnstein
    Replies:
    1
    Views:
    325
    Ken G
    Jan 7, 2005
  3. Dave

    Conversion from .csv format to .qif format

    Dave, Jul 21, 2004, in forum: Microsoft Money
    Replies:
    2
    Views:
    446
    Cal Learner-- MVP
    Jul 21, 2004
  4. David Arnstein
    Replies:
    3
    Views:
    809
    David Arnstein
    Jan 9, 2005
  5. hisplaceresort
    Replies:
    3
    Views:
    314
    Glyn Simpson, MVP
    Dec 29, 2006
Loading...

Share This Page