I am passing in a YEAR-MONTH value to Webfocus as 2008-05. The WHERE claus should altimately read something like this:
WHERE YEAR(RPT_HIST_VAL_DT) EQ '2008'
AND MONTH(RPT_HIST_VAL_DT) EQ '05'

Can someone please assist? Thank you,

It depends on the type of database and format of the date field.

Is it a relational or FOCUS database or is it a flat file?

Is the format of RPT_HIST_VAL_DT date-time or smart date or alpha?

Also, please update your signature in your profile (here: https://forums.informationbuilders.com/eve/personal?x_myspace_page=profile, under "View/Edit Complete Profile")

I am using a relational database(DB2 v8). It is a smart date: (FIELD=RPT_HIST_VAL_DT,RPT_HIST_VAL_DT,YYMD,DATE,MISSING=ON ,$)

Is it possible to say

WHERE PERIOD EQ '200805';

You can create a define that says

PERIOD/YYM=RPT_HIST_VAL_DT;

Or if you need this field always, you can create an extra field in the master that does the same.

FIELD=PERIOD,PERIOD,USAGE=YYM,ACTUAL=DATE,MISSING=ON ,$

would this work?

This works for me:

-SET &DATE1  = '2008-05';
-SET &DATE1I = EDIT(&DATE1,'9999$99');
-SET &DATE2 = AYM(&DATE1I, 1, 'I6');

TABLE FILE EXPENSEBASE
PRINT
*
WHERE EXPENSEDATE EQ '&DATE1-01' AND EXPENSEDATE LT '&DATE2-01';
END