I have a report that groups records by date. There will NOT be records for every calendar day in the records selected. For example, the report my select records from October 1st - October 31st. There may only be records for Oct 1st, Oct 5th, Oct 15, and Oct 23rd. I need to calculate the # of dates between record dates.
Oct 1st No Prior
Oct 5th Oct 1st
Oct 15th Oct 5th
Oct 23rd Oct 15th
There can be multilple records for any one day.
Is there a function to get the value of the previous group?