trouble with date when importing a just exported csv file.

[Larry Evans]

On 01/27/2015 08:19 PM, David Carlson wrote:
> On 1/27/2015 6:34 PM, Edward Doolittle wrote:
>> In North America SEC and OSC have a "T+3" rule for settling trades, which gives the buyer of securities three days to deposit any cash required for a purchase. While not exactly "buying on credit", it means that one does not in general need the cash in the brokerage account in order to buy securities, even in a cash/non-margin account.
>>
>> Sent from my iPad
>>
> Edward,
> Thanks for the information.  I knew that there were rules but I didn't
> know what they were.  My broker doesn't stick his neck out on that, even
> if I have the funds in another account that he is managing.  He would
> transfer the funds into the desired account first before issuing a trade
> order. 
> 
> I think that Larry was just using fictional transactions, but they may
> need to more closely match the way things really happen to work
> correctly in GnuCash. I know that reports would not give correct results. 
> 
> I was hoping that someone that understands and/or uses CSV imports
> enough to explain the date format issue and more would help.  I also
> have no idea whether GnuCash can import it's own exports, as that is not
> a normal use case either.

The page in the Gnucash manual:

http://www.gnucash.org/docs/v2.6/C/gnucash-help/ch04s02.html

says:

  Import Transactions from CSV...
	

  Starts the CSV Transactions file import process. The file to
  import must be a delimited file.

but I don't see on that page any more details.  In particular, I
see nothing about a date format.


OTOH, this post:

http://lists.gnucash.org/pipermail/gnucash-user/2012-April/044274.html

may give me a solution. However, that post does say,

  Choose your correct Date format

but I thought I did that when I selected the y-m-d "Date Format" as
shown in the 8.PreviewSettings.png file attached to my previous post :(

-regards,
Larry