Larry,
>>So, I may hope? :) BTW, have you already been the Member of the day? I don't remember...
>>
>>So, the probability may be calcualted as: (right?) in each particular day for each such person:
>>prob=1/337+1/336, if all these people had access in the last 20 days in each day.
>>
>It looks like Mark gave you the answer you were looking for. Also, I haven't been a MOTD. I think it checks the experience field as well. It says you have to have at least 100 characters in the field and I haven't filled it in yet.
I can not agree with his formula.
Ok, this is how I would deal with this situation:
ldDate=Date()
select * from UtMembers where abs(dateLastAccess-ldDate)<=20 and len(description)>100 and HasPicture into cursor curPotentialMembers
lnNumber=_tally
select *, recno() as Num from curPotentialMembers into cursor curNumbered
gnLower = 1
gnUpper = lnNumber
lnFirst= INT((gnUpper - gnLower + 1) * RAND( ) + gnLower)
lnSecond=INT((gnUpper - gnLower + 1) * RAND( ) + gnLower)
* Hopefully, they are not equal :)
select * from curNumbered where num=lnFirst or num=lnSecond
Is it right? And what would be probability, if, say, there are 200 members, which met the criteria?
If it's not broken, fix it until it is.
My Blog