I need help with developing a formu

[aud9]

I need help with developing a formula for a fiscal period that begins December 29, 2002 and ends December 27, 2003. Each qtr is made up of 4-4-5 wk periods. Where do I begin??? Desperately seeking an answer soon..!!! I need to be able to use the results with different datasets to determine activity in different periods.

 

[bdreed35]

There is an FAQ written on this topic:
faq767-1960

~Brian

 

[aud9]

bdreed35 I saw this FAQ but had some concerns because I was not working with a calendar year fiscal period. I will try this and will let you know what happens. Also, how did you use this formula in the report.
Thanks again,
Aud9

 

[synapsevampire]

You need the results of what?

First you state that you need a formula for a fiscal year, then you allude to something about quarters, then more vagueness regarding results with other datasets.

Do you have a specific requirement?

I also suggest that you post a minimum of technical information, such as the version of Crystal and database.

The simplest way to handle this sort of thing (and it solves so many other data extraction issues) is to take a page from data warehousing and create a Period table.

It's fairly simple to do, just create a table which has all dates (say for the next 10 years), with attributes for every date, such as fiscal year, fiscal quarter, year, quarter, weekday, weekend, holiday, etc.

Now left join this table to your data.

-k