i have created a cross tab report of procedures performed within our Fiscal year.  The data selection is fine but I need the cross tab to be grouped bi-weekly.  Our Fiscal year starts July 1.  They want the columns to start July 1 to July 14 and so on.  But the cross tab is still going off of calendar year.  The first column is June 24 to July 7, even though the data is only pulling for what was doen July 1 and on.  How can I reset the column date so it groups them biweekly starting July 1.  This corresponds with our payroll so they need to know procedures done within a pay period.

I thought I needed two different date fields  for a datediff?  I only have one date (date of service) I need them grouped on that.  Sorry very new to the more complex formulas and just self taught Crystal.

I will try that.  I used this and it works great but i have to group biweekly and this groups weekly. 

Thanks, worked.  Used FLOOR so it would start at the first pay period of the fiscal year.