On 2010 May 10, at 19:13 PM, Tom Bracken wrote: > How can i sort on the date field in a sheet? Suppose the format is > mm/dd/yyyy. Won't it be sorted on month? Thanks.
This solution is only moderately related to Tom Bracken's specific question, but ... if your dates are expressed in ascii (not expressed numerically and then displayed in ascii), then the format YYYY.MM.DD.hh.mm.ss does the trick. Sorting a list of such dates alphabetically automatically puts them in chronological order. And, it continues to work even if you right-truncate unnecessary small time units; e.g., YYYY.MM.DD.hh. Besides ... it's a logical way to express date-times; each block represents shorter time intervals as you move to the right unlike the cockamamie systems used in the U.S. and the (only somewhat better one) used in Europe. ____________________________________________ Charlie Rose Boulder, Colorado, USA Oberaudorf, Deutschland Web Site: http://www.ros5e.com My PGP Public Key: http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0xF57617F9
