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!


  • 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.

  • 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.