by David Morris » Mon, 02 Nov 1998 04:00:00
I'm trying to import a downloaded statement from my bank (Lloyds Bank
in the UK). When I import it the dates are wrong. If I look at the QIF
file I can see that the dates are in the US MM/DD/YY format rather
than the UK DD/MM/YY format.
Is this is a problem with the Money 99 import or has my back screwed
up on the formating of the file?
If I manually edit the dates into a UK format the import works fine
and all dates appear as they should do.
Dave
by Richard Bollar, MV » Mon, 02 Nov 1998 04:00:00
--
Have a question on using Microsoft Money? Visit the Unofficial Microsoft
Money FAQ at http://www.swizzle.com/msmoney/msmoney.htm
>I'm trying to import a downloaded statement from my bank (Lloyds Bank
>in the UK). When I import it the dates are wrong. If I look at the QIF
>file I can see that the dates are in the US MM/DD/YY format rather
>than the UK DD/MM/YY format.
>Is this is a problem with the Money 99 import or has my back screwed
>up on the formating of the file?
>If I manually edit the dates into a UK format the import works fine
>and all dates appear as they should do.
>Dave
1. TIP: Getting Money 2k (UK Version) to import .QIF files with US date format
Absolutely brilliant!! I've been struggling with this for the best part of
three years and your reg tweak fixed it in one go.
Thanks very much - great help.
Jim
3. Importing QIF File Produces Wrong Date Order
5. Converting UK Dates to US Dates for QIF import
7. Date field in Money 99 wrong format
8. @UserRoles returns empty list
9. Importing (QIF) Data in Money'97 - Date format problems
10. Date Formats on QIF import
11. Missing date field on import from .qif format
12. Transposed Dates in an Imported QIF File
13. export qif statement for import into money does not work