Fiscal Year

[beth4530]

How do you write a Crystal formula so when a fiscal year parameter is selected it calculates the time period for that fiscal year without having to manually update the formula for each FY period.

 

[lbass]

What is your fiscal year?

-LB

 

[beth4530]

July 1st to June 30th

 

[SkipVought]

What is your formula for a fiscal year period?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[beth4530]

IF FY2011 is selected then pull dates in 7/1/2010 to 6/30/2011

 

[lbass]

I ordinarily use a formula like this, where {?FiscalYear} is a number parameter, for a record selection formula:

{table.date} in date({?FiscalYear}-1,7,1) to date({?FiscalYear},6,30)

If you are trying to group your date fields based on fiscal year or use it in charts or crosstabs, you can use a formula like this:

"FY "+totext(year({table.date}+184),"0000")

-LB

 

[beth4530]

Thank you LB