Claudine - Try:
bro * fro d_invoice_status where inbox_state = 2 and state_changed_dt = (SEELCT (MIN(state_changed_dt)) FROM d_invoice_status where inbox_state = 2) Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of claudinerobbins Sent: Friday, March 04, 2005 4:44 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Date Function 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
