View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 4
Default Sorting DateTime Values in Array

I have an array of dates/times in the format "mm/dd/yy hh:mm". The
array is one-dimensional.

I want to pick the max/min, but it won't work. My code:

msgbox WorksheetFunction.Max(arrResults())

I am getting "0" when I run this code now.

I read he http://tinyurl.com/q6jm6 this is a misbehavior on Excel's
part and I'll have to find another way. The problem with the proposed
solution is that it uses dateserial function. I also need the time and
I don't think the dateserial function keeps the time (am I wrong?).

So here's my new thinking:

Couldn't I just sort the array and pick the first or last element as min
or max?

Anyone have a good bubble sort routine for date/time combinations OR a
friendly pointer on how to write one (i.e., what functions to use that
aren't broken/buggy). There seems to be few topics on this subject in
the newsgroups and I desperately need to get something working.

Thank you for taking the time to read my post.

-Kevin