Hi,
I am trying to write a formula to calculate the Date Diff between my start dates. I only want the report to calculate "Days Since Last Shot" for each group(Client). So i don't want to see the Difference in days between the last record of the previous group. So in the second group, i dont want to see 169, i want to see 0, but i do want to see the 68 on the next line. Does this make sense?
Here is what i am using now for my formula:
if not onfirstrecord then
DateDiff ("d",{StartDate},(PREVIOUS({StartDate})))