Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

This question reminded me this one rather old (OMG 12 years already?)

You can get the result by the sequence of 3 queries.

  • The first relates the table to itself and calculates the number of days.
  • The second limits the result to the smallest date.
  • The third relates the first two to get the desired result

In the following example, the table contains counter index statements.

Table1

What we want (run Q3 in C:\fakepath\DateDiffBetweenRecords.odb):

Q3

HTH - Regards