Parmeter formula for looking up date range in table

[SUEF]

I have an accounting period table that has the year and then a date range for each period. The format of the table is yyyymmdd for the dates. I would like to query the table and take the currdate find the current year based on the currdate then pull in the date range the currdate is in for my parmeters in my report. Anyone out there know how to write this statement?

 

[Turkbear]

Hi,
In the data, is the 'date' field an Actual DATE type? ( What database?)

As a seelction formula, if that is a DATE type, then try:

Year(CurrentDate) = Year({Table.DateField})

If the 'date' is actually a string then try:

Year(CurrentDate) = Year(Date({Table.DateField},'yyyyMMdd'))

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SUEF]

Thanks so much for your information. The database is iseries db2. The date field is just a number field in yyyymmdd format. I believe you would consider this a table lookup for the year, then lookup the currdate within the ranges in the file. The table has the fields year, date range. I want to select by first the year, then the date range from that record based on the currdate.

 

[Turkbear]

Hi,
OK, the formulas I posted are a little incomplete (I missed the part about the ranges ) - How is the date range specified - one field with 2 dates or 2 fields?





To Paraphrase:"The Help you get is proportional to the Help you give.."