On Fri, Sep 19, 2014 at 4:51 PM, [email protected] <[email protected]> wrote:
> when i import a csv file of 389 line items in 123 abc order i am unable to > put them in expirational order. they range from 9/06/2014 to 9/19/2015. > In addition to Roman's suggestion about the formatting also note 99,12/31/2014 88,1/1/2015 To import the above correctly "Detect Special Numbers" must be ticked AND column format of "Date (MDY)" for second column must be specified. However to import the following correctly 99,"12/31/2014" 88,"1/1/2015" it isn't necessary to tick "Detect Special Numbers" Don't know why. Just is. tested with AOO 4.1.0 on Ubuntu 14.04
