Getting the last 5 years automatically throug where clausile
Getting the last 5 years automatically throug where clausile
(OP)
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
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
RE: Getting the last 5 years automatically throug where clausile
The code would look something like this:
CODE
-SET &STARTYR = &DATEYY - 4;
-TYPE &THISYEAR &STARTYR
The -TYPE was to show what values were set. Then, in your request, you might code:
CODE