Money 2006 date format

#1 09-09-2005, 08:19 PM

In microsoft.public.money, Tim wrote:

- quote -

> Hi,
> I have bank accounts in the UK and in the US, and am trying to set up
> Money 2006 Deluxe to allow importing of statements from both countries.
> The UK banks use dd/mm/yyyy date format in their OFX files.

You are probably thinking of QIF files. All OFX files use yyyyMMdd.
At least they all start that way. They can be yyyyMMddhhmmss and
then some. the part after dd is optional.

- quote -

> The US
> banks use mm/dd/yyyy. Money seems only to handle one format - the one
> that the PC is set to use. As my PC is set to use US date format, the
> statement from my UK bank gets entered incorrectly (day and month get
> transversed).
> Ideally there should be a setting for each account to specify the date
> format that the bank uses, but according to Microsoft support there is
> not.
> Does anyone know of a way to correct this behaviour?

Assuming QIF, your choices are to change date format when you
process each, or to use a program to manipulate one of them.

- quote -

> Many thanks!
> Tim

09-09-2005, 08:11 PM

"Tim" <timothy_s_moore[at]yahoo.co.uk> wrote in message
news:1126295520.808676.98470[at]g49g2000cwa.googlegroups.com...
- quote -

> Hi,
> I have bank accounts in the UK and in the US, and am trying to set up
> Money 2006 Deluxe to allow importing of statements from both countries.
> The UK banks use dd/mm/yyyy date format in their OFX files. The US
> banks use mm/dd/yyyy. Money seems only to handle one format - the one
> that the PC is set to use. As my PC is set to use US date format, the
> statement from my UK bank gets entered incorrectly (day and month get
> transversed).
> Ideally there should be a setting for each account to specify the date
> format that the bank uses, but according to Microsoft support there is
> not.
> Does anyone know of a way to correct this behaviour?
> Many thanks!
> Tim

Open the OFX file in not pad, change the dates to mm/dd/yyyy format, save
the file then import it.

#-1 09-09-2005, 07:52 PM

Hi,

I have bank accounts in the UK and in the US, and am trying to set up
Money 2006 Deluxe to allow importing of statements from both countries.

The UK banks use dd/mm/yyyy date format in their OFX files. The US
banks use mm/dd/yyyy. Money seems only to handle one format - the one
that the PC is set to use. As my PC is set to use US date format, the
statement from my UK bank gets entered incorrectly (day and month get
transversed).

Ideally there should be a setting for each account to specify the date
format that the bank uses, but according to Microsoft support there is
not.

Does anyone know of a way to correct this behaviour?

Many thanks!

Tim

Similar Threads
Thread	Forum	Replies	Last Post
Date format in MS Money and Quicken QIF files are different. Conversion? David Arnstein: I use QIF files to transfer data from Quicken to Money. I find that Quicken 2005 and Microsoft Money 2005 use slightly different QIF files. In...	Microsoft Money	3	01-09-2005 10:42 PM
Date format in Money 99 Keyser: How could I change the date format to 09 may 2004 in Money 99, I tried the regional settings but I'm not sure which one to use. Thanks	Microsoft Money	1	05-07-2004 02:57 PM
Pocket PC Money 2004 US to UK date format bluebrown: Can the date on the POCKET version be amended to the UK date format dd/mm/yy? Have changed the control panel/regional settings to UK - which...	Microsoft Money	1	02-21-2004 06:15 AM
Changing date format in money 2002 mikewoolfall@tiscali.co.uk: I have recently had to rebuild my computer and re-install Money 2002. It now has american date format and bracketed debit numbers. How do I...	Microsoft Money	1	11-06-2003 10:03 AM
pocket money United kingdom date format Stuart beaton: Does anyone know if this can be achieved? If so how!	Microsoft Money	1	09-15-2003 01:23 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode