How do i obtain the nearest shipdate prior to Returndate.
here is my sample script. thanks. kindly check my script.
the result should be 2011-02-23
from Table1 as a
left outer join table2 as b
and b.shipdate <= returndate
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...