Referencing thread 767-1616297 Fiscal Quarters main and subreports

[hsandwick]

Fiscal Quarters - main and subreports

Resolution to this - sorry, lbass, just noticed I hadn't responded last year! Did find a solution, posting in case it's useful for others. Yes, I created parameters for "Month" and "Year" and then the specific db date must fall within the two formulae below.

Created a formula: CurrCum_FY_Start
//Dim message as String
If {?Year} <= Year(CurrentDate) then
If {?Month} = 3 then
DateSerial({?Year} -1,10,01)
else
If {?Month} = 6 then
DateSerial({?Year} -1,10,01)
else
If {?Month} = 9 then
DateSerial({?Year} -1,10,01)
else
If {?Month} = 12 then
DateSerial({?Year} 10,01)
else
DateSerial({?Year} -2,10,01);

If {?Month} = 3 then
DateSerial({?Year} -1,10,01)

============

Created a formula: CurrCum_FY_End
If {?Month) = 3
then
DateSerial({?Year} ,03,31)
else
If {?Month) = 6
then
DateSerial({?Year} ,06,30)
else
If {?Month) = 9
then
DateSerial({?Year} ,09,30)
else
If {?Month) = 12
then
DateSerial({?Year} ,12,31)
else
DateSerial({?Year} -1,09,30)

 

[Madawc]

It's good to leave replies, but since this is not a question you should have used the 'News' Icon

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[hsandwick]

Got it. Thanks for the good advice, Madawc.