Printable View
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?
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..Quote:
Originally Posted by brucevde
ToText(DateDiff ("ww", GroupName ({ORDERS.EDATE}, "weekly"),CurrentDate), 0) + " Weeks Old"
Sorry, I am not following your logic.Quote:
Since it is grouped weekly, I want to do it based off of the group name.
What is displayed and/or incorrect if you use
ToText(DateDiff ("ww", {ORDERS.EDATE},CurrentDate), 0) + " Weeks Old"