date format importing to Cashbook

Martin Le GriceMartin Le Grice Member Posts: 8
edited February 13 in Other Reckon Products
I am using an old version of Quicken Cashbooks and frustrated trying to import QIF files from my bank as it always imports the year as '20'. I think this is a limitation of the old software which only offers an import date format of DDMMYY or MMDDYY so I think it reads just the first 2 characters of '2017'. I have tried to find a way of editing this in Excel but the date format there can only be saved as ddmmyyyy (yes, I can change the way it displays in Excel but not the underlying date format.) Any suggestions would be REALLLLY welcome!

Comments

  • ShaneShane Reckon Staff Posts: 560
    edited February 13
    Hi Martin,

    Use notepad to edit it instead of Excel.  Then make the date ddmmyy and try importing.  In notepad you can do whatever you want.

    Regards,
    Shane.
  • Martin Le GriceMartin Le Grice Member Posts: 8
    edited November 2017
    Many thanks Shane - that's a great suggestion for editing - but I still have the problem of importing. I need to convert from a csv file to  qif, and if I paste back from notepad into csv it reverts to date format!! Unless you know a way of importing from notepad do you??
Sign In or Register to comment.