The specified input format is illegal

[samuel]

This message appears when i try to import transaction data. Specifications:

input format:
SYMB;DD.MM.YYYY;TRAN;BNUM;ANUM;CNUM

input file: hhhhhhhh.txt

^GSPC;09.08.2007;BUY;1;1474.25;2.4
^GSPC;09.08.2007;SELL;1;1475;2.4
^GSPC;09.08.2007;BUY;1;1472.25;2.4
...

[Mark]

Hi Samuel,

The year key is YY, not YYYY. This will match either a 2 or 4 digit year. Change your format string to:

SYMB;DD.MM.YY;TRAN;BNUM;ANUM;CNUM

and that should fix the problem.