cobolinx1
asked on
Crystal Reports Group by week label
I have a date grouped by week. How do I display the week value. Like 7/12/09 to 7/18/2009?
I tried something like this but it wants a date for the datedadd function.
I tried something like this but it wants a date for the datedadd function.
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,GroupName{Command.SENT_DATE}, "weekly") )
if the group name is a properly formatted date, you could use CDATE(GroupName{Command.SE NT_DATE}, "weekly")) inside your DateAdd formula
GroupName ({Command.SENT_DATE}, "weekly") & " to " & DateAdd ("d",6 ,CDATE(GroupName{Command.S ENT_DATE}, "weekly") ))
ASKER
It gives me the error "the ) is missing" on {Command.SENT_DATE} in the dateadd function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.