>When I do a copy to mySpredsheet type XLS in FP2.5 dates come into Excel as character
>When a user sorts on a date he gets all januaries all februaries etc.
>
>How can that be done right so the user can actually sort on a date column???
Hi, Peter.
It's not a nice solution, but the best thing we came up was to add a column with DTOS( datefield ) for sorting purposes. DTOS formats the date as a YYYYMMDD string, so it's always good ordered.