>I tested it in SQL Select. Why would you use two steps if it can be done in one?
I already had two selects in the original program, that's why my solution is acceptable. Otherwise I would use your suggestion.
After second thought, I think, you're right. I'll make this change tomorrow.
Thanks again.
>>>Following will return empty date if there are no records with DeedType = "LC", just tested.
NVL(MIN(IIF(DeedType = "LC", date, Null)), {}) AS MinLCActDate,
>>
>>Did you test it in SQL or just the command? Anyway, I already used two selects, so I leave min(iif(deetype='LC',date,{^3000-01-01})) and in the second select replace {^3000-01-01} with {}
>>
>< snip >
If it's not broken, fix it until it is.
My Blog