tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/47660-csv-import-says-dates-are-in-errorInfinite Kind: Discussion 2018-10-18T14:11:26Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/460894202018-09-16T12:59:07Z2018-09-16T12:59:07ZCSV Import says dates are in error<div><p>Hi Sue,</p>
<p>You can find the steps to import a CSV file in <a href="http://help.infinitekind.com/kb/online-banking-and-bill-pay/importing-csv-files">this article</a>. You shouldn't need to use the extension to import CSVs in the latest version of Moneydance but use the File --> Import action. Can you try this and let me know if you encounter any difficulties?</p>
<p>Ian O<br>
Infinite Kind Support</p></div>Ian Otag:infinitekind.tenderapp.com,2009-01-14:Comment/460894202018-09-16T14:48:38Z2018-09-16T14:48:38ZCSV Import says dates are in error<div><p>Hi Sue,</p>
<p>Thank you for the screenshots.</p>
<p>I was able to successfully import your CSV file using the CSV Importer.</p>
<p>Set up your Custom Reader per my screenshot. Pay careful attention to the Date format dd MMM yyyy.</p>
<p>You didn't include any Payment transactions in your screenshot. However, your CSV file does seem to include a 4th column. I opted to designate that 4th column to Payment transactions. This is something that you may or may not need. I can't tell for certain without seeing how Payment transactions are constructed in your CSV file.</p>
<p>HTH -Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/460894202018-09-16T16:43:57Z2018-09-16T16:43:57ZCSV Import says dates are in error<div><p>Thanks for taking the time to reply. I was able to get it working by editing the CSV as Ian O's reply suggested. Kevin, when I tried your fix it still wouldnt parse the dates. Can't see any difference to what you did but at least I have a workaround now.</p></div>smwhiteheadtag:infinitekind.tenderapp.com,2009-01-14:Comment/460894202018-09-16T17:01:25Z2018-09-16T17:01:25ZCSV Import says dates are in error<div><p>Hi Sue,</p>
<p>The date format that worked for me was dd MMM yyyy - with a single space between the parameters.<br>
The one you used, per your screenshot was dd-MMM-yyy. The dashes are what is causing the parsing problem.</p>
<p>I prefer the CSV Importer as I have several different credit cards that I need to create different custom readers for.</p>
<p>I'm glad to hear that the built-in importer works for you. Be aware that (for me) the built-in importer does not remember it's prior settings but rather, reverts to it's default settings.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/460894202018-09-17T15:08:22Z2018-09-17T15:08:22ZCSV Import says dates are in error<div><p>Kevin, Thanks, I've got it working now. I think i had failed to save my changes when I edited the date format in the custom reader so it kept reverting to the old format.</p>
<p>Thanks again. Sue</p></div>smwhitehead