Hi,
Crystal is querying a data source (Access table).
One of the fields is {session.session date}.
For each data set, this field will have a minimum of one date entry but will have no upper limit although 9 is probably going to be the max.
What I need to do is work out is:
- how many dates are in this field per data set, and from that:
- the date diff between the second to last date and the first one; and
- the date diff between the last date and the second to last.
Some data sets will have only one date, some will have two but most will have three or more.
Is this possible?
IP Logged
