Hi Allen

For the median do:

select datefield from table into cursor curtemp order by datefield

lnrecord=_tally/2

go lnrecord in curtemp

IF mod(_tally,2)=1

skip in curtemp

retu datefield

else

lndatetime1=datefield

skip in curtemp

return lndatetime1+(datefield-lndatetime1)/2

endif

Dr. Joerg Arand

Consultant Neonatologist

Neonatology

Children's Hospital

University Tuebingen

Calwer Str. 7

D-72076 Tuebingen

Tel.+49-(0)7071-2982211

Tel.+49-(0)7071-2980895 (office)

E-mail:Joerg.Arand(AT)med.uni-tuebingen.de

>>> "Allen" <profox@gatwicksoftware.com> 15.04.2014 10:23 >>>

Hi Foxgang

I am going round the bend with this. Situation. I have a file with

dates in

(datetime). The dates are not in order, and have a couple of idiots

inputs

including a year 2210 one plus a jan 2013 when it should be jan 2014.

Anyway most are good and in a range.

So what I want to do is set the order to the date (actually a datetime

fields) ok no problem.

Now I want to see what's halfway down. But....

Goto recount()/2 takes me to halfway down the original order which

could be

an early date (and is in the file I am trying to sort out). So the

question

is how do I find the halfway point in an ordered table. In other words

in

this case, halfway down the datetime field. No good looking at min and

max

as due to the idiot input of 2210 it turns out to be 2107. I cannot

assume

dates as these files are ongoing.

I've got over it with this by select distinct (datetime) order by

(datetime)

and going halfway but I am curious how halfway down an ordered table

can be

achieved

Al

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance:

http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list:

http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message:

http://leafe.com/archives/byMID/profox/001e01cf5884$030f3790$092da6b0$@com

** All postings, unless explicitly stated otherwise, are the opinions

of the author, and do not constitute legal or medical advice. This

statement is added to the messages for those lawyers who are too stupid

to see the obvious.

Report [OT] Abuse:

http://leafe.com/reportAbuse/001e01cf5884$030f3790$092da6b0$@com

--- StripMime Report -- processed MIME parts ---

multipart/mixed

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/534D30850200002D0005567D@gwia1.zit.med.uni-tuebingen.de

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.