Hi all, I'm trying to return a row based on the oldest date found in a datetime field. I have tried:
bro * fro d_invoice_status where inbox_state = 2 and (lmin(state_changed_dt)) RBase ignores this and returns all rows. My data looks like: 33979 --- 2 --- amontano --- 02/10/05 15:56:23 --oldest date 33979 --- 2 --- amontano --- 02/24/05 15:15:47 (min(state_changed_dt)) and (lmin(dextract(state_changed_dt))) yield no result Any ideas? TIA ~Claudine
