Its been a while since I've been in BI...this maybe very simple..

I need to do an if statement in a fex:

TABLE XXXX
PRINT YYY
ZZZ
.
.
.

IF the CURRENTMONTHNBR = '07' THEN GOTO JulyReportSelection
ELSE GOTO RegularReportSelection.


-JulyReportSelection
WHERE xxx = cccccccccccccccc
-GOTO CONTINUE

-RegularReportSelection
WHERE xxx = nnnnnnnnnnnnnnn
- GOTO _CONTINUE

-CONTINUE
.
.
.
END

This code essentially just directs to the appropriate WHERE statement for the month...

I seem to recall &YYMD but am unsure how to grab the month from it and incorporate it in this context...

This message has been edited. Last edited by: FP Mod Chuck,

&DATEM

And why not, once you have your month as per Tom suggested, perform as following to avoid GOTOs and embedded DM into Focus code ?

-SET &WHERECOND = IF &DATEM EQ '07' THEN 'WHERE COUNTRY EQ ''FRANCE''' ELSE 'WHERE COUNTRY NE ''FRANCE''';

TABLE FILE CAR
PRINT *
&WHERECOND
END

Much more less coding

What about

WHERE (CURRENTMONTHNBR EQ '07' AND xxx = cccccccccccccccc)
   OR (CURRENTMONTHNBR NE '07' AND xxx = nnnnnnnnnnnnnnn);

Good option Wep when the need is to have both conditions evaluated but not if it's as per a GOTO when only one of the conditions must be applied.