Group on Fiscal year 3

[dfwcharles]

Crystal 8 Sql 2000

I have a report of Purchase Orders that is grouped by the order date based on the year. This works great but I want to group on the fiscal year instead. The fiscal year is 12/1 to 11/30. What kind of formula could I use to do this? I dont have or want any kind of data parameter on the report.

Thanks

 

[bdreed35]

Create a formula like this, and then group on it instead of the order date:

if month({table.order_date}) in [1 to 11] then
cdate(year({table.order_date})-1,12,1)
else
cdate(year({table.order_date}),12,1)

~Brian

 

[dfwcharles]

Works great, thanks!