Query for Days Between Dates in Records

Posted in 1997

Alan Z. Scharf — Thu, 26 Jun 1997 19:38:19 GMT — source: Informix-list mailing list archive (1991-1998)

Is there an SQL query that would give the days between a date in a record and the date in the previous record? For Example: Date DaysBetween 1/1/97 0 3/15/97 73 4/17/97 33 5/14/97 27 Thanks very much. Alan Alan Z. Scharf GrapeVine Systems New York City _________________________ http://www.grapevines.com