>>>>I want to select min and max dates from some table. However, I want to select min not empty date. If all dates are empty, the resulting date should be empty, but otherwise it should be min non-empty. >>>> >>> >>>select ... Where Not EMPTY(MyDate) ... >>> >>>:-) >> >>Ok, I take it as a NO. Anyway, I wrote two selects already: >> ... > >Doesn't the following work? > >
>selectmin(MyDate) from MyTable where not empty(Mydate)
>
Thats what I think, but reread the bold text :-)
If we exchange an apple, we both get an apple. But if we exchange an idea, we both get 2 ideas, cool...
Gérald Santerre Independant programmer - internet or intranet stuff - always looking for contracts big or small :) http://www.siteintranet.qc.ca