Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

DateDiff between records on same table

Hi, I have a Base DB at work (HSQ) which has a table populated with thousands of records, one of the fields is a Date field. I need to find some way of querying the difference between each successive record, so “DateDiff” I guess. But how can I compare between record 1 and 2, then 2 and 3 etc etc.