Is the column that the dates are in formatted as a "date", or is it just a string?
It may be that you are sorting them as strings - if so, then "1/01/14" would come before "9/01/1943". Converting the column to a date format may solve the sorting issues. On Fri, Sep 19, 2014 at 1: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. > > there are only two columns one is domain name the one next to it is > expiration date. > > i tried the sort feature and the filters features and it just screws them > all up. it is a bad error on open office side. please fix and let me > know when ready. > > why is something so simple messed up by open office? > > thankyou. why are you so hard to reach? > > -- > thanks a bunch, > borga.........a.k.a. > [email protected] >
