I have a report that takes in two dates to display data in a date range. I need to limit it to where it will only allow a range of no more than 1 month. How would I go about that?

This message has been edited. Last edited by: Josh K,

I've figured out at least how to subtract dates.

  
-SET &DATE2 = 20130901;
-SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ;
-SET &ZD = &DATE2 - &WORKDATE;

But how do I use this to prevent the report from running if ZD > 33 or is negative, for example?

Tip 1: Don't use standard math functions for / with DATES. There are a lot of Date and Time Functions out there just for things like this.

Hint: F1 ... DATE

If this fits in with your program and logic, use an IF test then skip the report.

-IF &ZD LT 0 OR &ZD GT 33 THEN GOTO ERR_RANGE ;
.
.
.
-GOTO PGM_END

-ERR_RANGE

-* Error Handler here

-PGM_END