Date Problem

[pvuppa1]

Hi everyone, I have a date format problem. I need to format year in the following manner everything seems to be fine except setting YEAR=YEAR+1

YEAR/A4YY='&USEYEAR';
concatenating here for querying
TESTDT1/A8YYMD=YEAR | '0701';
BEGDATE/YYMD=TESTDT1;
...my query


have to add reset value of year to year+1 tried both
SET YEAR=YEAR+1; and
YEAR=YEAR+1;
gave me an error abt conversion from alaphanumeric to numeric.
Any ideas ?
-P

 

[kiddpete]

Try;

-SET &USEYEAR=&USEYEAR+1;
YEAR/A4YY='&USEYEAR';

the dash (-) in the first column tells Focus that this is a Dialogue Manager command.

HTH

 

[gizzy17]

If you are using a define when you try to add 1 to the Year, it won't work since YEAR is an alpha field. You would need to change it to an Integer field first.