Getting the last 5 years automatically throug where clausile

Ericordina · Jan 2, 2007

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 · Jan 8, 2007

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:

Code:

-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:

Code:

WHERE YEAR FROM &STARTYR TO &THISYEAR

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Getting the last 5 years automatically throug where clausile

Ericordina

Technical User

focwizard

Vendor

Similar threads

Part and Inventory Search

Sponsor