Getting the last 5 years automatically throug where clausile

[Ericordina]

Hello,

I'm trying to create an report in wich i can
use automatically the information of the last 5 years.

the field in the table is filled till 2099 and the max year must be the year eq system year.

I hope someone can give me some advise to solve this

greetings
eric

 

[focwizard]

From what you've described, you can use the Dialogue Manager to calculate the starting year of your 5 year span.
The code would look something like this:

-SET &THISYEAR =  &DATEYY;
-SET &STARTYR = &DATEYY - 4;
-TYPE &THISYEAR &STARTYR

The -TYPE was to show what values were set. Then, in your request, you might code:

WHERE YEAR FROM &STARTYR TO &THISYEAR