Date Counting

[rjdpa]

I have a report that is grouped by week. Under each week there are details. I want to sort it by oldest date to newest..... but here's the kicker... I want, in each group, to not only give me the week beginning date, but to also say "N Weeks Old" What's the best possible method of doing this?

[brucevde]

If you are using Crystal Reports a formula with something like the following might work for you

ToText(DateDiff ("ww",{Orders.OrderDate} ,CurrentDate), 0) + " Weeks Old"

[rjdpa]

If you are using Crystal Reports a formula with something like the following might work for you

ToText(DateDiff ("ww",{Orders.OrderDate} ,CurrentDate), 0) + " Weeks Old"

Since it is grouped weekly, I want to do it based off of the group name. I tried this but getting errors..

ToText(DateDiff ("ww", GroupName ({ORDERS.EDATE}, "weekly"),CurrentDate), 0) + " Weeks Old"

[brucevde]

Since it is grouped weekly, I want to do it based off of the group name.

Sorry, I am not following your logic.
What is displayed and/or incorrect if you use

ToText(DateDiff ("ww", {ORDERS.EDATE},CurrentDate), 0) + " Weeks Old"