Macro value not getting referred

[sayanapex06]

************************************************************************************** ;
%LET CURR = TODAY() ;

%LET PREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1), YYMMD.);
%LET PRPREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -2), YYMMD.);
%LET CURRMO = %SYSFUNC(TODAY(),YYMMD.) ;

************************************************************************************** ;

CREATE TABLE TOTDTL_CURRMO AS

(SELECT BILLING_YEAR_MONTH,
SERVICE_TYPE,
DESCRIPTION10_TO_IBS,
BILLING_SERVICE,
COMP_CODE,
REFUND_MONTH,
COST_OF_SERVICE,
UNITS,
TAX
FROM mydblib.t_other_detail_internal
WHERE BILLING_YEAR_MONTH = "&CURRMO");

QUIT ;

NOTE: Table WORK.TOTDTL_CURRMO created, with 0 rows and 9 columns.

&CURRMO  is supposed to have 2018-02 

but the value isn't getting in BILLING_YEAR_MONTH .

Could you please help me with this

[Reeza]

What’s the type and format of BILLING_YEAR_MONTH

---

@sayanapex06 wrote:

************************************************************************************** ;
%LET CURR = TODAY() ;

%LET PREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1), YYMMD.);
%LET PRPREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -2), YYMMD.);
%LET CURRMO = %SYSFUNC(TODAY(),YYMMD.) ;

************************************************************************************** ;

CREATE TABLE TOTDTL_CURRMO AS

(SELECT BILLING_YEAR_MONTH,
SERVICE_TYPE,
DESCRIPTION10_TO_IBS,
BILLING_SERVICE,
COMP_CODE,
REFUND_MONTH,
COST_OF_SERVICE,
UNITS,
TAX
FROM mydblib.t_other_detail_internal
WHERE BILLING_YEAR_MONTH = "&CURRMO");

QUIT ;

NOTE: Table WORK.TOTDTL_CURRMO created, with 0 rows and 9 columns.

&CURRMO  is supposed to have 2018-02 

but the value isn't getting in BILLING_YEAR_MONTH .

Could you please help me with this

---

[sayanapex06]

Billing_year_month is a field in a oracle database and we are establishing the conncection to it 

it should have values in 'yyyy-mm'

I am getting the yyyy-mm from code

how to get it in Billing_year_month ?

[Reeza]

Thanks, but That doesn’t answer my question.