>>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.
Thanks, I need an after the fact Excel-only solution, cause the sheets already exist.
In the future I will use type XL5 (thanks Tamar) and/or dtos with '/' added to make it YYYY/MM/DD (so it sorts and looks like a date)
Peter
Peter Cortiel