Date range dilemma

[nelliott]

The company year is split up into periods on a 4/4/5 week basis starting in October. I want to be able to automatically perform a search to show all the records from the last period and also show at the top of the report the date ranges and the year/period that the report relates to. The year would be 2002 for the 2001-2002 year, 2003 for the 2002-2003 year etc...

Not really sure where to start with this one. Hope somebody can help

Regards

Nick

[djgogi]

quote:

---

Originally posted by nelliott:

The company year is split up into periods on a 4/4/5 week basis starting in October. I want to be able to automatically perform a search to show all the records from the last period and also show at the top of the report the date ranges and the year/period that the report relates to. The year would be 2002 for the 2001-2002 year, 2003 for the 2002-2003 year etc...

Not really sure where to start with this one. Hope somebody can help

Regards

Nick

---

First give me some more input:

When is the first week for ex, if dayWeek of 10-01-someyear is sunday?

Dj

[djgogi]

Try this

code:

---

Case

(date <= If(Month(date) < 10, Date(-2, 92, Year(date)), Date(10, 92, Year(date))),"period1",

date <= If(Month(date) < 10, Date(-2, 183, Year(date)), Date(10, 183, Year(date))),"period2",

date <= If(Month(date) < 10, Date(-2, 274, Year(date)), Date(10, 274, Year(date))),"period3",

"perod4")

currentCompanyYear=Year(date)+ (Month(date) >= 10)

HTH

Dj

[IdealData]

Have a look at www.onegasoft.com.

There's a document on "Smart Ranges" that addresses this problem - but we're talking SERIOUS FileMaker.

If you can work out how to cook an elephant whole then you'll probably understand it.