I am trying to create a rolling three-year period for a graph.

TODAY/YYMD=DAYMD(&YYMD, YYMD);
TODAYYR/YY=TODAY;
BEGINYR/YY=TODAYYR - 3;

My BEGINYR would be used in my WHERE statement "WHERE BIRTHYR GT BEGINYR".

It is ignoring my year calculation. Any suggestions?

In the first line, the last arg is wrong.
Make it:

TODAY/YYMD=DAYMD(&YYMD, 'YYMD');

I think Jack caught your error, but one other thing I wanted to mention. I would HIGHLY suggest doing this calculation in Dialogue Manager using -SET &var= as opposed to a DEFINE. This type of calculation as you are using it cannot be passed to the DBMS so it will basically select *, then do the defines, then throw out the records it doesn't need. If you use DM, you can use the same calculations, but the end result is an &var which has the value substituted in the WHERE as oppposed to comparison agains a defined field. The selection criteria can then be passed directly to the DBMS.

WHERE BIRTHYR GT &BEGINYR.EVAL ;

Thanks Jack. It appears to be working, however my TODAY and TODAYYR fields return as 2009 now. Other than that it is working correctly. Any idea why 2009 would appear?

Same here!

-SET &ECHO=ON;
DEFINE FILE CAR
TODAY/YYMD=DAYMD(&YYMD, 'YYMD');
TODAYYR/YY=TODAY;
BEGINYR/YY=TODAYYR - 3;
END
TABLE FILE CAR
HEADING
"&YYMD &DATE &DATEYYMD "
" "
PRINT TODAY TODAYYR BEGINYR
BY COUNTRY
ON TABLE PCHOLD FORMAT WP
END

echo:

DEFINE FILE CAR
TODAY/YYMD=DAYMD(20080612, 'YYMD');
TODAYYR/YY=TODAY;
BEGINYR/YY=TODAYYR - 3;
END
TABLE FILE CAR
HEADING
"20080612 06/12/08 2008/06/12 "
" "
PRINT TODAY TODAYYR BEGINYR
BY COUNTRY
ON TABLE PCHOLD FORMAT WP
END


output:

  PAGE     1
  
  20080612 06/12/08 2008/06/12
   
  COUNTRY     TODAY       TODAYYR  BEGINYR                                                                                        
  -------     -----       -------  -------                                                                                        
  ENGLAND     2009/06/12  2009     2006   
  FRANCE      2009/06/12  2009     2006   
  ITALY       2009/06/12  2009     2006   
  JAPAN       2009/06/12  2009     2006   
  W GERMANY   2009/06/12  2009     2006   

Obviously there's a problem with DAYMD. Suggested detour:

TODAY/YYMD='&DATEYYMD';

The DAYMD is for Legacy dates only, no detour necessary.
DEFINE FILE CAR
TODAY/YYMD='&YYMD';
TODAYYR/YY=TODAY;
BEGINYR/YY=TODAYYR - 3;
END
TABLE FILE CAR
PRINT TODAY TODAYYR BEGINYR
BY COUNTRY
END
PAGE 1

COUNTRY TODAY TODAYYR BEGINYR
ENGLAND 2008/06/13 2008 2005
FRANCE 2008/06/13 2008 2005
ITALY 2008/06/13 2008 2005
JAPAN 2008/06/13 2008 2005
W GERMANY 2008/06/13 2008 2005

Dane,

It would be good to know what version and platform you ran that on. Please update your signature so that we can reference your reply to a version and platform.

T

I tested it on Dev Studio 764, however the release is irrelevent. This will work on all release that support Smart dates.

IMHO, the release date is NEVER irrelevant. Constant code changes and code "tightening" cause little things known as bugs or "undocumented features" that appear and disappear seemingly at random. and

There are at least a couple of different current issues where date functions using smart dates do not work consistently between versions.

quote:

The DAYMD is for Legacy dates only

Ah, yes. DAYMD and "smart" dates use different epochs, 365 days apart:

DAYMD has 1899-12-31 as Day Zero; smart dates, 1900-12-31.