how do i convert that column to date format from whatever it is as it comes from go daddy? it is just a .csv file.
i use open office. On Fri, Sep 19, 2014 at 2:02 PM, Roman Sausarnes <[email protected]> wrote: > 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] > > > -- thanks a bunch, borga.........a.k.a. [email protected]
