Hello! <BR>I am not an expert at writing SQL QUERIES and I just write the basic ones.<BR>I have a date field called received. <BR>There are other two date fields assigned and reassigned.<BR>I want to write a statement to select the records in a manner that, it takes the latter date between assigned date and reassigned date and calculates the difference of days between received and assigned/reassigned whichever is latter, and is ordered by difference in those days! Is it possible ??<BR>Thanx in advance for any help on this matter.