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" <[email protected]> 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: [email protected]
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: [email protected]
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/[email protected]
** 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.
