>>>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
I forgot, I deveolped the solution with a hlookup() function and it works
Peter
Peter Cortiel