Groupong by Date

[davidmo]

In one report I want to group items that were created prior to 4/1/2003 and group items that were created after 4/1/2003. Not sure how.

 

[IdoMillet]

Create a formula that returns "Before" or "After" depending on the date and group on that formula.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Here's an example of the formula.

Insert->Field Object->Right Click Formulas->New:

If {TableDateField} < cdate(year(currentdate),4,1) then
&quot;Prior to 4/1&quot;
else
&quot;4/1 or after&quot;

Insert a group by this formula.

-k