return the earliest date
423548Jul 5 2004 — edited Jul 6 2004I'm trying to return the earliest date from 5 different date fields. The scenario is: if the File_date is null, compare the conv_date, process_date, Detail_date and Dis_date and insert the earliest of them into the field New_file_date.
I'm in the loop and I would like to skip (if possible) assining a variable to all dates and comparing them one by one.
Any idea will be appreciated.
Thanks,
MJ